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 )
|