M
Mike Saffer
Greetings everybody,
I tried 3 other answers given in the archives first but still haven't been
able to sucessfully make this one work with VLOOKUP.
My formula in B6:
=IF(ISERROR(VLOOKUP(A6,H7:M121,3)),"",VLOOKUP(A6,H7:M121,3,FALSE))
I'm looking for for an exact match to A6 in column H of my VLOOKUP table
H7:M121 and return the value in the 3rd column, in this case column J.
Here's the kicker. I deliberately excluded what I was looking for in A6,
from cloumn H, trying to force an error of #N/A or #VALUE. Well, in this
case I got the #N/A error. error. I also tried =if(ISERROR(....... but no
joy. The error is still visable.
I was hoping to get a blank in B6 when there is an error, instead of a zero,
or #N/A, or #VALUE.
As always I appreciate any help.
Thanks,
Mike
Jacksonville, Florida
I tried 3 other answers given in the archives first but still haven't been
able to sucessfully make this one work with VLOOKUP.
My formula in B6:
=IF(ISERROR(VLOOKUP(A6,H7:M121,3)),"",VLOOKUP(A6,H7:M121,3,FALSE))
I'm looking for for an exact match to A6 in column H of my VLOOKUP table
H7:M121 and return the value in the 3rd column, in this case column J.
Here's the kicker. I deliberately excluded what I was looking for in A6,
from cloumn H, trying to force an error of #N/A or #VALUE. Well, in this
case I got the #N/A error. error. I also tried =if(ISERROR(....... but no
joy. The error is still visable.
I was hoping to get a blank in B6 when there is an error, instead of a zero,
or #N/A, or #VALUE.
As always I appreciate any help.
Thanks,
Mike
Jacksonville, Florida