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)


"karenofcourse" wrote in message
...
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