vlookup - how to not show #n/a as a value on graph?

[tlyee]

Hi,

I have this formula in my lookup sheet

=IF(COUNTIF($F$2:$H$20,C24),VLOOKUP(C24, $F$2:$H$20,3,FALSE), NA())

and then, another worksheet that contains graphs and a table that tie to the data in the lookup sheet.

Example of one of the cell. Lkup is name of the lookup sheet.
=IF(ISERROR(Lkup!K7),"",Lkup!K7)

In the worksheet of the graph, the cell will not show any value if there is nothing in the lookup sheet.

I have a table in the worksheet graph that shows the numbers that link to the lookup sheet. It isn't displaying any n/a value in my table. Down side is, I would like to display the value to the graphs. Right now it is showing all the #N/A in the graph.

How do I make them invisible on the graph??

Hope this is clear... Please help.

Thanks!

 

[PaddyD]

"Hope this is clear... "

Sorry, but wasn't to me. Care to try again, this time including some of the content, as well as the form of your problem.