Converting the error "#N/A" into a cell value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to convert the error "#N/A" into a value; e.g., when the MATCH or LOOKUP function returns #N/A, I would like to change this error to 'no match', but the IF function will not accept #N/A to do this.
 
Ron,

=IF(ISNA(Yourformula),"No match",YourFormula)

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

RonLev said:
I would like to convert the error "#N/A" into a value; e.g., when the
Click to expand...
MATCH or LOOKUP function returns #N/A, I would like to change this error to
'no match', but the IF function will not accept #N/A to do this.
 
=IF(ISNA(ORIGNAL FORMULA),"NO MATCH",ORIGINAL FORMULA)

-----Original Message-----
I would like to convert the error "#N/A" into a value;
Click to expand...
e.g., when the MATCH or LOOKUP function returns #N/A, I
would like to change this error to 'no match', but the IF
function will not accept #N/A to do this.
 
YW Ron,
It's always nice to get feedback and to know that things work well.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Give this a try.



=IF(ISNA(VLOOKUP($AW9,Pivot!$A$5:$J$490,6,FALSE))=TRUE,"N
Match",(VLOOKUP($AW9,Pivot!$A$5:$J$490,6,FALSE)))

Gre
 
Back
Top