vlookup #N/A

  • Thread starter Thread starter Darren Savage
  • Start date Start date
D

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
 
One way

=IF(ISNUMBER(MATCH(A1,Sheet2!A2:A100,0)),VLOOKUP(A1,Sheet2!A2:B100,2,FALSE),
0)
 
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





.
Click to expand...
 
Try again

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