I guess you can use List option under validation and then use VLOOKUP to
display the other data.

I can get into details if you give me some more information.

Thanks


wrote in message
oups.com...
I'm trying to create a drop down menu full of items. Once an item is
selected from this menu, all of the item's corresponding data is
displayed.

The item's data would be for example a field such as "A27:T27" and I
want the entire field displayed.

Any ideas?