Excel Truel - Data Validation, VLOOKUP, and IFERROR: Episode 1651
2,745 views · Published 22 February 2013 · 7:59 · Indexed 14 November 2026
Channel: MrExcel.com · 2013 · Education
Microsoft Excel Tutorial: VLOOKUP Function for Beginners. Welcome back to another episode of Trueling Excel! I'm Bill Jelen from MrExcel and I'm joined by Mike Girvin from Excel is Fun for our annual Excel is Funner podcast. In this episode, we'll be discussing the powerful VLOOKUP function. Our special guest, Isaac, demonstrates how to use VLOOKUP to create a drop-down list that displays names and corresponding bikes. He shows us how to use the mouse to enter the formula, but I'll be using the arrow keys to navigate through the formula. Remember to always end your VLOOKUP with "False" or "0" to avoid any errors. But what happens if there is an error? Mike introduces us to the IFERROR function, which allows us to display a custom message instead of an error. We can even use this function with data validation to create a dynamic drop-down list that updates when new data is added. Speaking of data validation, I'll be showing you a neat trick to convert your data into a table and still maintain the dynamic range for your drop-down list. This is a great way to keep your data organized and easily add new entries. We hope you enjoyed this episode and learned something new about VLOOKUP. Don't forget to subscribe to our channel for more Excel tips and tricks. See you next time! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Introduction to VLOOKUP (00:15) Explanation of VLOOKUP and its uses (00:45) Step-by-step guide to using VLOOKUP (02:38) Demonstration of VLOOKUP in action (03:00) Alternative method for entering formulas (03:30) Adding input messages to data validation (04:00) Importance of using "False" in VLOOKUP formulas (05:15) Using the IFERROR function to handle errors (06:07) Using VLOOKUP with tables (07:30) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: Adding data validation to a table in Excel Converting data to a table in Excel Creating drop-down lists in Excel Dynamic ranges in Excel tables Excel data validation Excel formulas with VLOOKUP Excel tips and tricks for beginners Handling #N/A errors in VLOOKUP Sorting data in Excel Using IFERROR function in Excel Using VLOOKUP in Excel VLOOKUP tutorial Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153473/ Today, our 'Dueling Podcast' has Three: Mike, Bill, and Isaac show Data Validation, VLOOKUP, and IFERROR in their annual "Trueling Excel" podcast. Follow along with Episode #1651 as Mike and Bill are schooled on the use of Microsoft Excel. Dueling Excel Podcast #110...This episode is the video podcast companion to the book, "Slaying Excel Dragons: A Beginners Guide to Conquering Excel's Frustrations and Making Excel Fun", by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle] http://www.mrexcel.com/slayingdragonsebook2011.html and "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! http://www.mrexcel.com/learn2010/LE2010.html "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920