Search This Blog

Tuesday, May 28, 2019

Use VLOOKUP to Find the 2nd Match (or nth Match)

If you are familiar with the VLOOKUP function it's a great tool to lookup values in a range or table. However it will only bring back the first instance of the looked up value. What if you wanted the second instance of the value or even have all the instances of the value brought back? This could be done by using a helper column and the COUNTIF function. Watch the video to see how it's done!

No comments:

Post a Comment