Using a Drop Down Menu

J

JenJo

Hi all,

I'm trying to auto fill a row with data from another area within my
worksheet based on a drop down menu. The menu is all text, no numerical
values. Based on what a user selects from the drop down menu (7 options) the
next 4 columns in the same row will pull data (7 options) from another area.
Is there a way to do this and if so, how?

Thanks so much!
 
G

Gord Dibben

See Debra Dalgleish's site for working with VLOOKUP tables.


Gord Dibben MS Excel MVP
 
Top