VLookup w/ Error.Type

  • Thread starter Thread starter Linda
  • Start date Start date
L

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
 
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
 
Back
Top