| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup with the result being once cell below the orginal value
Hi
I have a vlookup in which I wanted to return the value for the cell right below what would have the orginal cell. This is the Formula I have. The result will return the value in E100 since the value looking is in A100. I want the resulting value to be in E101 instead. =VLOOKUP($M2,Sheet1!$A$10:$H$4009,5,FALSE) Any assistance is appreciated. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup with the result being once cell below the orginal value
Use this instead
=INDEX(E10:E4009,MATCH(M2,A10:A4009,0)+1) -- Regards, Peo Sjoblom "Alex" wrote in message ... Hi I have a vlookup in which I wanted to return the value for the cell right below what would have the orginal cell. This is the Formula I have. The result will return the value in E100 since the value looking is in A100. I want the resulting value to be in E101 instead. =VLOOKUP($M2,Sheet1!$A$10:$H$4009,5,FALSE) Any assistance is appreciated. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup with the result being once cell below the orginal value
Use MATCH to find the row and then incorporate into an INDEX formula. Look
in the help index for MATCH & INDEX -- Don Guillett Microsoft MVP Excel SalesAid Software "Alex" wrote in message ... Hi I have a vlookup in which I wanted to return the value for the cell right below what would have the orginal cell. This is the Formula I have. The result will return the value in E100 since the value looking is in A100. I want the resulting value to be in E101 instead. =VLOOKUP($M2,Sheet1!$A$10:$H$4009,5,FALSE) Any assistance is appreciated. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup with the result being once cell below the orginal value
Try this:
=INDEX(Sheet1!$E$10:$E$4009,MATCH($M2,Sheet1!$A$10 :$A$4009,0)+1) -- Biff Microsoft Excel MVP "Alex" wrote in message ... Hi I have a vlookup in which I wanted to return the value for the cell right below what would have the orginal cell. This is the Formula I have. The result will return the value in E100 since the value looking is in A100. I want the resulting value to be in E101 instead. =VLOOKUP($M2,Sheet1!$A$10:$H$4009,5,FALSE) Any assistance is appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup does not give the result in the cell even though it is | Excel Worksheet Functions | |||
| Excel 2007, How do you keep orginal cell border after highlighting | Excel Discussion (Misc queries) | |||
| vlookup shows result one cell above the expected result | Excel Worksheet Functions | |||
| Can I sort values only & leave orginal cell formatting? | Excel Discussion (Misc queries) | |||
| VLOOKUP formula appears in the cell I need to see the result in | Excel Discussion (Misc queries) | |||
Hybrid Mode
