Lesson 3-23 from: Microsoft Excel 2013 Expert Skills (167 Video Lessons)

Quality

LOW

Captions

OFF
Transcript

OFF

Speed

1x

Use an IFERROR function to suppress error messages

Play The Video

ExcelCentral.com

Play

Back 10 Seconds

Slower

Faster

Full Screen View

Online Video Course: | Microsoft Excel 2013 Expert Skills | |
---|---|---|

Session: | Session 3: Advanced Functions | |

Lesson: | Lesson 3-23 Use an IFERROR function to suppress error messages | |

Description: |
This video lesson demonstrates how to suppress error messages by using the IFERROR function in Microsoft Excel formulas. In this lesson's example, you'll see how IFERROR can be used along with a VLOOKUP function to hide the error codes that appear if the VLOOKUP isn't able to find a match. |