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…