Inserting data from drop down plus additional information

[Betraystewart]

Morning all,

First time posting here, just joined up.

I am struggling with my basic knowledge of Excel.

I have managed to create a drop down in Sheet1 A2 from a list of items in Sheet2 A - At the moment this field is currently blank and would like to put some sort of title on it so I know there is a drop down there and that I need to select something.

In addition I would like to automatically insert the additional information from Sheet2 C3:E5 into Sheet1 C2:E2 depending what I have chosen from the drop down.

Ie, Sheet1 A2, I choose Bread, I want C2:E2 to auto populate with what would be Sheet2 C3:E3.

Many thanks.

[BadlySpelledBuoy]

Hi,

I've simply added another value to the top of the validation list "Select Item" that you can have in the cell as default.
There are other ways of doing this, but it would be far more complicated than is necessary.

I've then used INDEX/MATCH to feed in the subsequent data you mentioned. I've wrapped that in IFERROR to take care of any N/A errors that may show up. Be warned that this will not work if the workbook is to be viewed in Excel 2003 or earlier.

If you're likely to be often adding new items to the drop down list, you may want to consider running the data validation from a dynamic named range so you don't have to keep adjusting it manually.

Hope that helps.

BSB.

[Betraystewart]

Perfect BadlySpelledBuoy. Thank you so much!
+Rep

[BadlySpelledBuoy]

Happy to help