Main Profile

At A Glance

Excel Lookup/Search Tip 5 - Vlookup - Assign Values Instead of Errors to a Vlookup with IFERROR

Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. Use the new IFERROR() function in Excel 2007 in conjunction with the VLOOKUP() function in order to never have to see another error displayed in Excel. The IFERROR() function allows you to display whatever default value you want in a cell if the original formula returns an error. This is an example of a nested function or formula since the Vlookup function is actually placed inside of the Iferror function. The IFERROR function is a great addition to Excel 2007 and should be learned by everyone who uses Excel. For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Length: 05:18

Contact

Questions about Excel Lookup/Search Tip 5 - Vlookup - Assign Values Instead of Errors to a Vlookup with IFERROR

Want more info about Excel Lookup/Search Tip 5 - Vlookup - Assign Values Instead of Errors to a Vlookup with IFERROR? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question