VLOOKUP return #N/A
Hi William,
=IF(ISERROR(VLOOKUP(A6,$B$6:$C$30,2,FALSE)),"",
VLOOKUP(A6,$B$6:$C$30,2,FALSE))
Note that the table array in vlookup must be absolute with the $ signs. Also
the above is one line even though it may appear as 2 lines in this post.
--
Regards,
OssieMac
"William Beard" wrote:
If VLOOKUP(A6,B6:C30,3,FALSE) returns #N/A (error value),
can I convert that #N/A into a blank cell?
If so, how do I do it?
Thanks
|