Formatting the Results of VLOOKUP

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
Back
Top