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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assign numerical value to cell based on selection from drop-down m 1
Filtered drop down list 2
Drop Down Menu 4
Select drop down menu option using libre-calc macro 0
Creating drop downs in a cell contingent on another drop down 1
Drop Down Menus 1
Drop Down choice needs to lead to another drop down menu 1
Data-Validation -List - Pick from a drop down menu 4

Top