Thread
:
Vlookup with the result being once cell below the orginal value
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
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.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett