Iferror

Resolved · Low Priority · Version 2010

Fri 3 Jun 2011, 16:42 Delegate Jacqui said...

Jacqui has attended:
Excel Advanced course

Iferror

not covered in the course please can you provide an example

Mon 6 Jun 2011, 11:21 Trainer Mark said...

RE: Iferror

Hello Jacqui,

Thank you for your question regarding iferror function.

This has many uses and was introduced in version 2007. An example could be where you are using exact Lookups and if it cannot find what its looking for, instead of the non de-script N/A error appearing, you could use the IfError to show a more meaningful message. Such as "Not Found".

e.g.
=IFERROR( VLOOKUP( "Jim", A1:B5, 2, FALSE ), "not found" )

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

Mon 13 Jun 2011: Automatically marked as resolved.

Excel tip:

Create a hyperlink navigation sheet

In large files, it is often useful to have a front sheet with hyperlinks to the key databases and summary calculations in your spreadsheet. Hyperlinks can save you and (more importantly) those less familiar with your spreadsheet a great deal of pointless scrolling between and within sheets.

Hyperlinks appear as underlined text and can jump to any cell or range name in your file. You can also use hyperlinks to jump to other files.

To create a hyperlink to a location in the active workbook: (1) Select the cell that contains the text you want to use as the hyperlink and choose Insert|Hyperlink.(2)Click Place in this document.(3)Choose the sheet you want to link to or the range name from the list of "Defined Names".(4)If necessary, type the cell reference in the Type in the cell reference box. (5) Click OK.

View all Excel hints and tips

Iferror

Iferror

RE: Iferror

Excel articles

Excel tip:

Create a hyperlink navigation sheet