INDEX

Episode 697 – VLOOKUP or INDEX?

               

Mel sends in today’s question. She prefers VLOOKUP, but her husband prefers INDEX and MATCH instead of VLOOKUP. In Episode 697, we’ll take a look at when to switch from VLOOKUP to INDEX and MATCH. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute(…)

Episode 518 – Copy Across

               

Richard sends in todays question: How do you copy a formula horizontally when it’s reading from a vertical list? Episode 518 shows the easy, but unintuitive solution. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277(…)

Episode 500 – 500!

               

As we hit this milestone, you can win one of a treasure trove of prizes, including a video iPod, great books from QUE, and more. There are over 40 prizes in all. Also in Episode 500, I draw the winner for the March/April challenge of the month, using a combination of Advanced Filter, INDEX, and(…)

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 485 – Index & Offset

               

These two functions allow you to dynamically point to a cell or a range. While they are often useless on their own, they can be used as arguments to another function. Episode 485 introduces these two functions. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two(…)

Learn Excel from MrExcel