Look up formula

[Guest]

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,

 

[Ron Coderre]

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)

 

[Ron Coderre]

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

Regards,

Ron

 

[Pete_UK]

Yes it can - if you are using VLOOKUP, for example, then you would
need to set the fourth parameter to FALSE or 0, meaning that you want
an exact match so sort order is not important. I'm a bit confused with
what is a name and what isn't in your description, so here's a generic
approach:

=VLOOKUP(D1,Sheet2!B:F,5,0)

Put this in F1 of Sheet1 and if the value in D1 is matched in column B
of Sheet2 then it will return the corresponding value from column F of
Sheet2 - if an exact match is not found, then it will return #N/A.

Hope this helps.

Pete