View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arvi Laanemets Arvi Laanemets is offline
external usenet poster
 
Posts: 510
Default Cell identification for a 'lookup'

Hi again

Sorry, I didn't see that the return value is in column left to lookup
column. The VLOOKUP needs the lookup column to be leftmost in lookup range.
You have to redesign your sheet, or you have to use more complex formula,
like

=INDEX($A$1:$A$1000,MATCH(MAX($B$1:$B$1000),$B$1:$ B$1000,0),)


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )