Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |