Formatting the Results of VLOOKUP
 

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.
--
LPS

You can use COUNTIF to see if the value exists. If so,
use VLOOKUP. For example:

=IF(COUNTIF(A:A,F1),VLOOKUP(F1,A:C,3,0),"")

HTH
Jason
Atlanta, GA

-----Original Message-----
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.
--
LPS
.