View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
phil phil is offline
external usenet poster
 
Posts: 201
Default Help with Lookup(), VLookup

I have some data in one sheet similar to this:

100.0 2.2
200.0 3.1
300.0 1.9
400.0 2.8

On another sheet, I want to find the maximum value for column 2; i.e. 3.1
(which I can do) and then I want to find the corresponding value in column 1,
i.e. 200.0.

Can someone tell me how to get this?

Thanks,

Phil