at, if statement with text, such as if(product), then (price)

K

karenofcourse

I have a price list with descriptions, item codes and prices. I just want to
use something simple like an at, if statement to tell the worksheet if this
product is selected from my drop down list, then return this price and item
code. I'm sure this is so simple, but I'm not having any luck.
Please help
Thanks
 
B

Bob Phillips

Assuming the Dropdown is in B2, and the price list is in M1:O20

=VLOOKUP(B2,$M$1:$O$209,2,False)

and


=VLOOKUP(B2,$M$1:$O$209,3,False)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top