Hello,

I have a vlookup statement that, when the table is empty, it returns a -
(dash).

Dependant upon that vlookup cell, I have the following IF statement
=IF(B51="",NA(),B57)

The IF statement does not work because of the dashes, but I have tried other
alternatives in the "" to recognise the dashes, but none work.

How do I modify the IF statement to recognise the dash as "no entry" and
return the N/A. Once the N/A is returned, a conditional format changes the
font colour to the same as the background. I am using the N/A to avoid my
graph showing the line at zero.

Thanks in advance.
Ant