Try Debra's nice coverage on VLOOKUP or INDEX/MATCH at her:

http://www.contextures.com/xlFunctions02.html
VLOOKUP

http://www.contextures.com/xlFunctions03.html
INDEX/MATCH

There's also some sample workbooks available for d/l & study
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Francois" wrote:
I have tried a number of things and searched all over but can't figure out
how I can link other cells to a list item.

Example - if I select a specific item from the drop down list I want to be
able to get the price for the item as well from my price list, which could be
in the same worksheet or workbook.

Just trying to built a simple calculator for material used.