vlookup for 2nd, 3rd, etc occurrance
How about something like =VLOOKUP(lookupvalue,tablearray,colindexnum,range_lookup,occurrance) like =VLOOKUP(123,A1:B100,2,FALSE,3) where the 3 means to return the 3rd occurrance of the lookup value. Of course, #N/A if there isn't one.
Tejal Gupta commented
I agree for this suggestion.. as many of us struggle and make a long formula to get 2nd and 3rd occurrence.
Kenneth Barber commented
Here's an alternative wording: Make a version of VLOOKUP that returns an array of all matches so then we can use INDEX to choose the one that we want.