That's a standard VLOOKUP formula. I presume you have a list somewhere
with these items and prices? Try VLOOKUP in this format to specifically
get the data:

Sheet2=Column A - your items
Sheet2=Column B - your prices
Sheet2=Column C - item codes
A1= your drop down selection (perhaps on sheet1)

=VLOOKUP(A1,Sheet2!$A$2:$C$100,_2_,FALSE) -gets price
=VLOOKUP(A1,Sheet2!$A$2:$C$100,_3_,FALSE) -gets item code


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=45527