Excel Drop Down Menu - Select List Item - (Show Data Associated With That List Selection.)

Hello,

I have created a drop down list.

My goal is the following: Once an item from the list is selected, I want other data associated with that item to be pulled up in a row or column on the same worksheet.

How do I do this?

Use VLOOKUP or INDEX/MATCH to bring back the data using the selected drop down list value as the reference.

If you need more help than that, perhaps you could post some example data with details of what data you wish pulled up.

That depends on the type of data you want to pullup. But, one option is to have lookups like the attached.

Choose from the "GRAY" dropdown list.

Perfect. I will compose a Vlook up and get that going. Thank you both for the prompt response.

I require the same help as well. To make things simple lets try to break down the lengths of a couple different items.

Take the following image:
excel help.jpg

So I manually enter WIDTH and HEIGHT and select the TYPE from a drop down list (its either O, XO, O/V)

I want the rest of the cells to fill automatically.

So TYPE O would only have Left Side, Right Side, Top, Bottom

TYPE XO would have Left Side, Right Side, Top, Bottom, and VERTICAL MIDBAR

TYPE O/V would have Left Side, Right Side, Top, Bottom, and HORIZONTAL MIDBAR

Your help is appreciated