Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • LastSunday, LastSaturday Date and Time
  • CONVERT function CONVERT
  • Extract Address into table Formulas - combined functions
  • Shades of gray Graphics
  • UDF – Convert Number into text (English and Arabic) User-Defined f(x)s = UDF
  • OFFSET+MATCH Formulas - combined functions
  • Hyperlink usage and HyperlinkOf UDF CELL
  • IF with AND and IF with OR AND

New function IFERROR, finally

Posted on December 24, 2017 By ANmar

We have already gotten used to use VLOOKUP, MATCH and other functions that generates errors inside an IF

But, we do not need that anymore

We can use the new guy, IFERROR instead, which will show the result if it did not generate error, otherwise will show something else if it resulted an error.

So, when we have this table ..

We can search for an item in first column, using VLOOKUP for example …

=VLOOKUP(J5,C:G,3,FALSE)

Which will result in an error if the item was not in list

But, if we inserted IFERROR outside of VLOOKUP, like this

=IFERROR(VLOOKUP(J5,C:G,3,FALSE),"Not found")

We can show anything if that item was not found …

 

A nicer way than the #N/A, don’t you think?

 

IFERROR, VLOOKUP

Post navigation

Previous Post: OFFSET+MATCH
Next Post: IF with AND and IF with OR

Related Posts

  • Sorting with functions only CHOOSE
  • SimpleANBox Basic Math
  • Text-to-Columns, dynamically using formulas IFERROR
  • VALUE() of LEFT() Formulas - combined functions
  • VLookup Lookup and References
  • Searching table in 2 dimensions. Formulas - combined functions

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (82)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (5)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • CTRL+Y a mini macro Excel User tips
  • WorksheetName and WorksheetsNo UDFs Lookup and References
  • Text-to-Columns, dynamically using formulas IFERROR
  • Limited Ceiling Basic Math
  • Excel Limits Excel User tips
  • Convert 2-column into wide (column-row) table Formulas - combined functions
  • CHOOSE – tree of decisions CHOOSE
  • Stale values (Scratched functions) Excel User tips

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme