Drop Down Lists

[mojobaabby]

Is there a way to have a drop down list with say 600 options from 4 different brands. When I choose an item from the drop down i would like the associated price shows up in a designated cell???
Too much to ask or not clear enough let me know.
Thanks

AC7 when chosen price to show up in AE7

[SDruley]

You have a very organized mind.

You might want to set up relational databases inside Access. Access is designed to do what you are asking.

[shg]

In AE7, =VLOOKUP(AC7, Sheet2!$A$1:$C$102, 3, FALSE)

You can omit the last argument of sheet2 col A is sorted ascending, but be very sure this is so before changing it.

You aren't doing yourself any favors with your worksheet design. The blank rows and merged cells will cause problems, now or later.

[mojobaabby]

thanks much appreciated