maximum value received through vlookup

[dpk]

Sheet1
A B
5 4.5
5 5.5
5 5.4
5 8.6
5 1.2
6 5.6
6 6.4
6 5.6
8 5.6
9 1.0

sheet2
A B
5
i use =max(vlookup(sheet1:a1,sheet1a1:b11,2,0) for result 8.6 bcoz 8.6
is maximum no. for 5 but result is 4.5 bcoz it is first answer for it

 

[Pete_UK]

VLOOKUP will always return the first matched item, and only that item
- that is the way that it works !

Pete