VLookup w/ Error.Type

[Linda]

Is there a way to have the #N/A's that result from a
VLookup to show a 0 instead?

I tried using the Error.type function, but it only works
when the Vlookup is #NA (it puts a #N/A instead of the
VLookup result). Here's an example of what I tried, but
failed.

=IF(ERROR.TYPE(VLOOKUP(Acct,Sept,{4,5,6,7},0))
=7,0,SUMPRODUCT(VLOOKUP(Acct,Sept,{4,5,6,7},0)))

Thanks in advance.
.....Linda

 

[Dan E]

Linda,

I didn't test this but

=IF(ISNA(VLOOKUP(Acct,Sept,{4,5,6,7},0)),0,VLOOKUP(Acct,Sept,{4,5,6,7},0))

Dan E

 

[Linda]

It worked like a charm!!

Thanks for your help.
....Linda

-----Original Message-----
Linda,

I didn't test this but

=IF(ISNA(VLOOKUP(Acct,Sept,{4,5,6,7},0)),0,VLOOKUP (Acct,Sept,{4,5,6,7},0))

Dan E

"Linda" <[email protected]> wrote in

message news:[email protected]...