Hi!
I want to do a vlookup on sheet 1, for a value from sheet 2, but each value from sheet 2 has multiple associated values on sheet 1. Each value from sheet 2 has multiple entries in sheet 1. when i do a vlookup it always brings back the first value in sheet 1, but i want it to pull back the first occurrence the first time, the 2nd the second time, and so on. Does that make sense?
Welcome to the forum. We just had a very similar discussion on this thread - both advanced filter and formula solutions provided (posts #7 and #8).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks