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!
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!