G
Guest
When I use the VLOOKUP function with a Range_Lookup of False, if the function
cannot find an exact match, it returns the result: #N/A, which is correct.
What I would like to know is, can I format that cell so that if the result is
#N/A, then the cell displays as blank or empty? I know I can format a 0
(zero) value to display an empty cell but can I format a text one like that,
as well?
Thank you.
cannot find an exact match, it returns the result: #N/A, which is correct.
What I would like to know is, can I format that cell so that if the result is
#N/A, then the cell displays as blank or empty? I know I can format a 0
(zero) value to display an empty cell but can I format a text one like that,
as well?
Thank you.