I am trying to modify my Vlookup code based on a match value. The column of data includes a cost type value (1-10) which only has one occurrence with cost codes 1500-25000 that can occur multiple times. Vlookup only pulls that first occurrence of the cost code. When I use match( 5, 'Report'!A1:A150, 0) excel outputs 68. I want to use that value to modify my Vlookup code from (A6, 'Report'! A8:M150, 3, false) to (A6, 'Report'!A68:M150, 3, false).
I think you mean this:
=VLOOKUP(A6,INDIRECT("'Report'!A" & MATCH(5, 'Report'!A1:A150, 0) &":M150"), 3, FALSE)
Hope this helps.
Pete
It took a little debugging but it did exactly as I wanted. Thanks for your help.
JonLanguasco, if you had to modify Pete's formula to get it to work for you, please post the final solution.
If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."
If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon below their name.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks