Learn Excel – “4-Way Lookup”: Podcast #1413

Use INDEX and INDIRECT to create a 4-Way LOOKUP!

Dueling Excel – Dynamic OFFSET or INDEX?: Podcast #1384

Dueling Excel – Episode #75 with Mike and Bill!

Learn Excel – Green Bay Packers: Podcast #1365

“What could have been” – Revisted…

Dueling Excel – Select and Concatenate: Podcast #1364

The Excel Help File? Who uses that – we have YouTube!

Dueling Excel – Three Way Lookup: Podcast #1328

A Dueling Three-Way Lookup: 2 Criteria with Multiple Ranges…

Dueling Excel – “Sort with a Formula”: Podcast #1308

Today Dueling Excel looks at RANK, VLOOKUP, COUNTIF, LARGE and more!

Dueling Excel – “Copy Down for Across”: Podcast #1298

Dueling Excel #56: Refer across Columns as you copy a formula down the rows . . . Bill and Mike show us how!

Dueling Excel – Extract State: Podcast #1276

Extract State: A Dueling Excel Podcast using VBA and Formula Functions to . . .

Where is the Last in Row?: Podcast #1254

Looking at the INDEX and MATCH Functions . . .

Duel: Portugal – 1139 – Learn Excel from MrExcel Podcast

A viewer from Portugal sends in a question about finding which row contains the match. Episode 1139 shows you a few ways to go!

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!