vlookup #N/A

[Darren Savage]

I'm running the VLOOKUP function on an array and am using
the optional FALSE formula to give me an exact match.
However this leads to #N/A being shown when the match
isn't exact. Is there a way of getting this #N/A to show 0
in the cell instead?
thx

 

[Peo Sjoblom]

One way

=IF(ISNUMBER(MATCH(A1,Sheet2!A2:A100,0)),VLOOKUP(A1,Sheet2!A2:B100,2,FALSE),
0)

 

[Darren Savage]

The reponse came with "Massage Unavailable"?

 

[Darren]

thanks - will try it out

-----Original Message-----
One way

=IF(ISNUMBER(MATCH(A1,Sheet2!A2:A100,0)),VLOOKUP (A1,Sheet2!A2:B100,2,FALSE),
0)

--

Regards,

Peo Sjoblom





.

 

[Peo Sjoblom]

Try again

=IF(ISNUMBER(MATCH(A1,Sheet2!A2:A100,0)),VLOOKUP(A1,Sheet2!A2:B100,2,FALSE),
0)