|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 1st, 2008, 05:53 PM
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
May 1st, 2008, 05:59 PM
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
May 1st, 2008, 06:00 PM
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
May 1st, 2008, 06:08 PM
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
