I am doing an inventory for all the businesses of a street. I have a two sheets, where on one I have different categories for commercial uses.
Each category displayed in sheet 1 has a number (1 to 132), and right of that number is the name of the category. Sample sheet:
In sheet 2, when I enter for example "5" in column 1, I would like to have that linked to sheet 1 so that in column 2 excel automatically displays the name of the category: "pharmacie".