VLOOKUP function
There is a table as below:
A B
1 11 20
2 12 21
3 12 22
4 13 23
5 12 24
If I input the function "=vlookup(12,A1:B5,2,0)", the result would be "21"
since Excel would find the first "12" (wich is in cell A2) in column A.
However, when I would like to find the last "12" (which is in cell A5) in
column A, that is the answer "24"(in cell B5) is required, how can I modify
the function? Please help me.
|