| 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. |
| 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) | |||
Threaded Mode
