Learn Excel from Bill Jelen with this daily 2 minute video podcast.

Monday, April 16, 2007

Episode 487 - VLOOKUP LEFT

To finish up the recent discussion of VLOOKUP, INDEX, MATCH, and OFFSET, today’s episode talks about the strange situation where the data that you want is located to the left of the key field in the lookup table. Episode 487 will show you how to use VLOOKUP and MATCH to solve this problem.

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 tips from the book!