Soldato
Need some help with Excel please friends! I did things like this in Uni, but with years of not touching it it's all forgotten. I think I need to use a vlookup/hlookup but I'm not sure.
I've got one sheet (products) with the columns Product ID, Name, Category and Price. This is filled with numerous products, all with unique IDs.
I've got another sheet (order) with the same columns (empty at the moment). I want a user to select a product ID from a dropdown list in the first column, and then it automatically fill the row with name, category and price of the product (retrieving the info from the Products sheet).
I'm sure its straightforward but I'm lost, please help!
I've got one sheet (products) with the columns Product ID, Name, Category and Price. This is filled with numerous products, all with unique IDs.
I've got another sheet (order) with the same columns (empty at the moment). I want a user to select a product ID from a dropdown list in the first column, and then it automatically fill the row with name, category and price of the product (retrieving the info from the Products sheet).
I'm sure its straightforward but I'm lost, please help!
