I have two column like this:
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? =)