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

[RonLev]

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.

 

[A.W.J. Ales]

Ron,

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

--
Regards,
Auk Ales

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

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.

 

[Robert Nguyen]

=IF(ISNA(ORIGNAL FORMULA),"NO MATCH",ORIGINAL FORMULA)

-----Original Message-----
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.

 

[RonLev]

Thanks; you and Bob were helpful within minutes of my posting

RonLev

 

[RonLev]

Thanks Bob, you and AWJA had the ready solution.

RonLev

 

[A.W.J. Ales]

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 *

 

[Gbonda]

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