How do I get multiple data returns from one drop down box?

T

Tracey

I have one drop down list with our product names and would like to have 2-3
other types of information on each product returned to other cells in the
spreadsheet.
 
D

Dave Peterson

If you build a table with all the info to return, you could use =vlookup() to
retrieve that other info:

=if(a1="","",vlookup(a1,sheet2!a:e,2,false))
to get the assocated value in column B.
 
Top