hide #n/a in excel code example Example: hide #n/a in excel =IFERROR(VLOOKUP(value,table,2,FALSE),"message")