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

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

Pete

On Mar 5, 9:14*am, dpk wrote:
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