Hi.
I have a table which is connected to a line graph.
The table is formulated using data collected using the hlookup. When a cell is blank in the table, the data appears as blank and not 0. However, when i put this table into a line graph, the blank data appears as 0 on the line graph (producing a marker at 0).
How do i change the hlookup formula to make a blank cell appear blank on the line graph?
The example of a hlookup formula i have used is - =hlookup($o$21,$bc$6:$bl$56,$bb14+1,0)
i have tried if(hlookup($o$21,$bc$6:$bl$56,$bb14+1,0))="",NA(),hlookup($o$21,$bc$6:$bl$56,$bb14+1,0)) but that didnt seem to work.
Does anyone have any ideas?
Please help!
Bookmarks