Hi all,
I have a row with numbers that are the result of a VLOOKUP function, and I want cells to be blank (empty) when the source of the lookup is blank. The cells must be blank, not 0, because the results are plotted in a chart where blank values are interpolated.
The current formula is:
=IF(ISBLANK(E2),"",VLOOKUP(E2,R2:S12,2,FALSE))
This results in "" being interpreted as 0 in the chart . What do I use in stead of ""?
Thanks!
This message was edited by MJ on 2002-02-25 20:39
This message was edited by MJ on 2002-02-25 20:40
I have a row with numbers that are the result of a VLOOKUP function, and I want cells to be blank (empty) when the source of the lookup is blank. The cells must be blank, not 0, because the results are plotted in a chart where blank values are interpolated.
The current formula is:
=IF(ISBLANK(E2),"",VLOOKUP(E2,R2:S12,2,FALSE))
This results in "" being interpreted as 0 in the chart . What do I use in stead of ""?
Thanks!
This message was edited by MJ on 2002-02-25 20:39
This message was edited by MJ on 2002-02-25 20:40