Good afternoon all! This is my first post so am hoping it will get some attention and a solution.
To keep it as simple as possible my spreadsheet has two sheets to it. Sheet2 contains a list of items, along with product codes, descriptions and costs, Sheet1 is my main page which I will be collating all of the correct items on to do further calculations on later.
sheet2 as shown below:
Sheet1.png
Which is a stock list of items, which for now will remain as is and not be updated.
Sheet1 Row A has the same headers as sheet 2. Column A has a validated data list taking the product code from sheet2 as shown:
Sheet2.png
My question is: If I select a product code into cell A2 on sheet1 from the drop down list, is there a formula that would automatically insert the associated data from sheet2 cells B2,C2,D2 into cells B2,C2,D2 on Sheet1? As shown:
Sheet1 ideal.png
Many Thanks in advance for any input you may give.
Alan
Bookmarks