Thread: Look up formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Emma Emma is offline
external usenet poster
 
Posts: 55
Default 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,