Todays question involves doing a Range Lookup using a VLOOKUP Formula. Bill shows us how to set this up based on the Data Range provided and explains why today’s VLOOKUP will be ending with a ‘TRUE’ statement instead of the usual ‘False’. See how and why its done in Episode #1570.


"Learn Excel 2007 through Excel 2010 from MrExcel" by Bill Jelen…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

Visit us: for all of your Microsoft Excel Needs!

Do you need more information about VLOOKUP Forumulas in Excel? Check out the “VLOOKUP WEEK 2012 Blog” for Beginner through Advanced Techniques with VLOOKUP and a variety of other ways to attain ‘Lookup’ results!