Look up formula
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,
|