Episode # 487 - VLOOKUP LEFT

Sponsored by

Learn Excel from MrExcel

Check out this book for more tips
similar to this lesson!

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.

You don't need to go spend an entire day at the local computer chain store to learn Excel. Take 3 minutes to learn this lesson now with our free video!

Watch Video

Click Play icon to play the video. You might first need to click on the Video to activate Flash player.

Tags/Keywords for this video: Formulas, VLOOKUP

More Excel Video Lessons

If you like this video, there are hundreds of 2-5 minute videos available here: