Dueling Excel – “Prevent VLOOKUP from Returning Zero” – Podcast #1750
Today Dueling Excel – with Mike ‘ExelIsFun’ Girvin and Bill ‘MrExcel’ Jelen – looks at a solution for VLOOKUP. Instead of allowing the result to return a ‘Zero’, when the matching Record in the Lookup Table is Blank, Bill and Mike Duel with various solutions to replace the ‘Zero’ with the Text, “No Price Found”. Follow the Excel-lent adventure of Episode #1750 to learn the secret of showing a Message instead of a Number with your VLOOKUP.
See It – Learn It – Use It! Everything you ever wanted to know about VLOOKUP- Including INDEX, MATCH and More! “ExcelIsFunTM“, by Mike “ExcelIsFun” Girvin is a 6 Week Course teaching you what you need to know to utilize VLOOKUP and get REAL RESULTS! With 4 Hours of video taking you step by step through the understanding, use and power of the LOOKUP Function family you will begin to develop an intuitive use and appreciation for the LOOKUP Function.
And for a great, rounded experience in learning more, check out…
“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! 35% More Tips than the previous edition of Bill’s book!
“The Learn Excel from MrExcel Podcast Series”
MrExcel.com — Your One Stop for Excel Tips and
*And a NOTE for our regular viewers: Yes…there was no Episode #1749 in the available listing…but it is here, lurking and slated to be released soon. Stay tuned…
Entry filed under: 2013, Beginning Excel, Bill Jelen, Ctrl+Shift+Enter, Dueling Excel, Dueling Podcasts, Excel, Excel 2010, Excel 2010 In Depth, Excel 2013, Excel 2013 In Depth, Excel for Business, Excel for Educators, Excel for Students, Excel For Teachers, Excel Formula, Excel Function, ExcelisFun, Holy Macro! Books, Learn Excel 2007 through Excel 2010, Learn Excel 2010, Learn Excel 2013, Learn Excel 2013 from MrExcel, Learn Excel from MrExcel, LOOKUP in Excel, Microsoft Excel, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel MVP, Microsoft Excel MVP Summit 2013, Microsoft MVP, Mike Girvin and Bill Jelen, MrExcel, MrExcel Podcast, MrExcel Products, Office 15, Tables in Excel, VLookup, VLOOKUP WEEK. Tags: 2010, 2013, accounting, Bill Jelen, Blank Cell, business, Custom Number, Dueling Excel, Excel, Excel 2010, Excel 2013, ExcelIsFun, format, Formatting, formula, Functions, Go To Special, GoToSpecial, Learn Excel, Learning, Mike Girvin, MrExcel, spreadsheets, technology, tutorial, VLOOKUP, Workbook, Worksheet.