Ooops....My response was intended for another question (sorry)

Regards,

Ron

"Ron Coderre" wrote in message
...
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,