Dueling Excel – “Prevent VLOOKUP from Returning Zero” – Podcast #1750

July 12, 2013 at 5:24 pm


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.

ExcelIsFun_2013_180Todays’ Dueling Excel Podcast #131 is brought to us by Mike’s new DVD, “ExcelIsFunTM – Covering it all, from your First VLOOKUP to more Advanced Uses of LOOKUP Functions.

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…

Advertisements

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: , , , , , , , , , , , , , , , , , , , , , , , , , , , .

Learn Excel – “Dynamic Range for a Pivot Table” – Podcast #1748 Learn Excel – “Transpose While Keeping Live Links” – Podcast #1751


Learn Excel from MrExcel

Learn Excel Podcast Splash Screen

The Excel Beginners Book:

"Don't Fear The Spreadsheet" - by Tyler Nash, Bill Jelen, Tom Urtis and Kevin Jones

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 742 other followers

Live Lessons Excel 2010 DVD

"Live Lessons Excel 2010" DVD

RSS MrExcel Recent Articles

  • An error has occurred; the feed is probably down. Try again later.

Recent MrExcel Tweets

MrExcel Podcast Archive


%d bloggers like this: