VLOOKUP formulas

D

Donna

I am trying to create a VLOOKUP formula using data from a drop down list.
My goal is to have the user select an item from the list and certain item
specific variables are filled in from a table. Can anyone help me.
 
D

damorrison

when In excel check out the help index and choose vlookup
the excel help, will help alot and you can use the function wizard as
well...........
 
P

paul

i may have misread your message
say you have a drop down list which returns your item selected in A1
you have your table of data in a10:C20
in say A2 type =vlookup(a1,A10:C20,2,false)&" "&vlookup(A1,A10:c30,3,false)
this formula assumes that you have a table in a10:c30 in which the items in
colA are the same items in your list.The false argument means vlookup will
only return an exact match,and by combining two lookup formulas you will get
the item fron col b and colc in the same row as your matching item.
ie lookup green from list
in your table green is column a grass is col b and red is col c
the above formula will return grass red
 
Top