Hi all,
In the attached Vlookup is not working through the whole column. Example see cell C5010. The vlookup data is in column AG, AH. You can see see it is searching based on data in A5010 which is in the data column.
So what the heck....
Hi all,
In the attached Vlookup is not working through the whole column. Example see cell C5010. The vlookup data is in column AG, AH. You can see see it is searching based on data in A5010 which is in the data column.
So what the heck....
This should work for you. (I'm a little biased towards INDEX MATCH).
C4375 =INDEX(AH:AH,MATCH(A4375,AG:AG,0))
Drag down column C.
The ranges in your VLOOKUP did not include all of the data in columns AG and AH.
If you prefer to use VLOOKUP, you can use this:
=VLOOKUP(A4375,AG:AH,2,0)
If you want to specify the exact range where the data is, you can use this:
=VLOOKUP(A4375,$AG$4:$AH$6314,2,0) <--eww gross
Last edited by 63falcondude; 05-31-2017 at 01:59 PM.
Hi Falcon thanks. Any reason it was excluding those rows in C? Just for sake of mind.
If you are trying to extract the values within the same sheet (Vlookup named sheet), select the range from AG4 to AG6314.
Start practicing Index Match formula, so you can extract values even on both sides. Vlookup cannot extract values on the left side or behind the lookup value column.
Write formula like this:
Index(Select the range of cells where the values to be extracted available,Match(look up value- select the cell which you would like to match up with, Lookup array- select the range of cells where the lookup values are available,0))
INDEX($AH$4:$AH$6314,MATCH(A4375,$AG$4:$AG$6314,0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks