IF ISNA or ISREF phrase

**Swaski** · 04-27-2016, 05:28 PM

Thanks in advance for your help. I'm using google sheets btw. Not excel.

When using =filter to grab data that matches the criteria.
if there are multiple of same criteria in Sheet3, then it will return as #REF.
if there are no match found, it will return as #NA.

excel if isna isref.jpg

Question: How do I turn #NA & #REF to display as different word?

I know I can use =iferror but that applies to all error. I hope to have a phrase for #NA ("not found") and #REF ("duplicate").

Thanks again.

**oeldere** · 04-27-2016, 05:53 PM

you can try this one:

if(yourformula="#N/A"","not found",if(yourformula="#REF","duplicate",yourformula))

**MrShorty** · 04-27-2016, 05:56 PM

I would guess that you will want to use the ERROR.TYPE() function inside of an IF() function or a lookup function to choose what to do with each error type. https://support.google.com/docs/table/25273?hl=en