First, take a look at Debra Dalgleish's Order Form example:
http://www.contextures.com/xlOrderForm01.html
It explains how to select items from a dropdown list and display
corresponding prices.
Is that something you can work with?
Post back if you have more questions.
--------------------------
Regards,
Ron (XL2003, Win XP)
Microsoft MVP (Excel)
"Emma" wrote in message
...
I need to look up cells in one work sheet and match cells in another and
return and number from a different cell.
Look up cell in Fri 4D column d (column D is a name)
match cell in 4dAverage in column B (column B is a name but in different
order than column D in 4D worksheet)
then return number from 4D Fri column F to
worksheet 4dAverage column f.
Can excel do this? Can it match names from one worksheet that are in
another worksheet if they are in a different order?
Thanks,