K

#### Kipi

A B

1 23

2 21

4 20

1 19

4 18

....etc (The numbers in column A are random and do repeat)

What I want to do is to look up a specific value in column A, like 4, and

return the corresponding value of column B with the largest row number, in

this case it's 18 not 20

Any suggestions? =)