| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Non-sequential VLOOKUP function -OR- sequential sort of web query | Excel Worksheet Functions | |||
| I want to use Vlookup function and AND function in a single formu. | Excel Worksheet Functions | |||
| carrying a hyper link when using the vlookup function | Excel Worksheet Functions | |||
| carrying a hyper link when using the vlookup function | Excel Worksheet Functions | |||
| Regarding IF function or vLOOKUP function | Excel Worksheet Functions | |||
Threaded Mode
