Attempting to match values in column E with column G and insert the corresponding number (column H) into column F
See attached workbook for example.
Hoping to do this using VBA, not just a VLOOKUP.
The code below, places 0 values into the correct rows of column F, instead of the correctly associated value.
Please Login or Register to view this content.
Last edited by Shearwater; 07-23-2014 at 10:26 AM.
Why don't you use VLOOKUP in the code?
Please Login or Register to view this content.
If posting code please use code tags, see here.
Norie,
having used a similar formula to match column data without the offset, for a different data series, now aiming to increase my understanding of the formula by extracting data from an offset column matching in a similar manner. VLOOKUP only reads left to right, but gaining an understanding of this would enable reading right to left at a later date.
The references aren't right in the second part of the formula.
Try this
Please Login or Register to view this content.
Norie,
That does the trick, thank you for your assistance.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks