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
--
paul

remove nospam for email addy!



"paul" wrote:

this link may help
http://www.contextures.com/xlDataVal02.html
otherwise post an example of what you have and what you want to acheive
--
paul

remove nospam for email addy!



"Donna" wrote:

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.