Episode 486 – Match & Index


In today’s podcast, we have hundreds of rows of VLOOKUP functions. Learn some tricks to make the entry of the third argument easier using a hidden row or the COLUMN function. Ultimately, though, after several iterations of VLOOKUP solutions, Episode 486 finally gets to the point of replacing VLOOKUP with MATCH and INDEX functions. This(…)

Episode 484 – VLOOKUP vs MATCH


The VLOOKUP function is one of the most versatile functions in Excel – you can use VLOOKUP to add item descriptions to a database containing item numbers. Episode 484 shows you how VLOOKUP works. This is the first in a series of podcasts to compare VLOOKUP with INDEX and MATCH. This blog is the video(…)

Learn Excel from MrExcel