Offset Lookup - Episode 1188

Find a value in this row and then get the values 1 and 2 columns to the right of that value. Mike and Bill duel it out in Episode 1188.

...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!

Duel: Unsorted VLOOKUP - 1144 - Learn Excel from MrExcel Podcast

Martin from Sweden sends in a question about doing a range VLOOKUP where the lookup table is not sorted. Mike and Bill duel it out in today's Episode 1144.

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!

TRIM VLOOKUP table - 1138 - Learn Excel from MrExcel Podcast

Rod from Cincinati asks how to solve the problem of trailing spaces in the lookup table. I had never tried it before, but you can apply a TRIM to the entire lookup table. Episode 1138 shows you how.

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!

Blank Row for Missing Dates - 1103 - Learn Excel from MrExcel

Sam from Vienna sends in today's question. In a database of events, how can he add new blank rows to represent every missing day? Episode 1103 shows you one method.

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!

Duel: Multiple Wildcards - 1090 - Learn Excel from MrExcel Podcast

In today's dueling Excel podcast, the question is how to delete all the records which contain either ski or swim. This requires multiple wildcards in a filter. Mike and Bill will compare various methods in Episode 1090 .

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!

Last Match II - 1083 - Learn Excel from MrExcel Podcast

Daniel from Quebec sends in a wild formula to solve the Last Match problem from Episode 1073. We'll look at using Evaluate Formula to study how the LOOKUP value actually works. Episode 1083 shows you how.

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!

MrExcel's Learn Excel #1000 - Dueling: Reverse Lookup

Bill and Mike take a look at how to do a reverse lookup in Episode #1000.

This video is the 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!

MrExcel's Learn Excel #926 - Double Lookup

Jim has two lists that he wants to match, but some records are missing from one list or the other. There are many ways to solve this. Episode 926 will show the classic double-lookup method.

This video is the 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!