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.
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.
Your response is the best, I've mistakenly clicked to other reply.
I tried the same thing you have given but I thought that there may be some other way.
I tried the same thing you have given but I thought that there may be some other way.
You're welcome! Glad it worked as desired.
Not to worry, a moderator will notice it and fix it for you.