Forum Discussion
Solved
Vlookup second, third, fourth & so on values
Vlookup How find second, third, fourth & so on values whose occurrence has more than 1 may be 10 times? sheet attached
One simple approach is, insert a helper column A and place the following formula in A2 and copy it down.
In A2
=C2&"-"&COUNTIF(C$2:C2,C2)And then use the following VLookup formula to get the desired output...
In K2
=VLOOKUP(I2&"-"&COUNTIF(I$2:I2,I2),$A$2:$E$31,5,0)Refer to the attached with formulas in place.
the weight for truck no RJ19GF9998 is same i.e. 30 which is wrong.
Apparently, I misunderstood the original question. "Weight" didn't appear to have anything to do with it. The way I read the question, he was trying to find all of the occurrences of something -- "How find second, third, fourth & so on values" -- and then, since VLOOKUP had been his reference, as VLOOKUP does, find other associated values. FILTER does that. But it apparently is not what he was seeking after all.