Learn Excel Episode 486: Match & Index

Posted in Companies, Podcasts on July 07, 2008


Learn Excel 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.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel