Step 1: Make a table on another sheet with these example headings:
Choice, ItemID, UnitPrice

Step 2: Fill in the items in the table

Step 3: Select the table cells and name the range LU_Items

Step 4: Select only the Choice items (not including the heading) and
name that range LU_Choice

Now go back to your initial sheet:
Cell A1: DataValidation
--Allow: List
--Source: =LU_Choice

Cell B2(ItemID): =VLOOKUP(A1,LU_Items,2,0)
Cell G1(Qty Input cell): some number
Cell H1(Price): =VLOOKUP(A1,LU_Items,3,0)
Cell I1: =G1*H1

Does that help?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=391593