| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Vlookup finds a blank, but returns a zero - HELP!
I have a chart, and several series contain data that comes from elsewhere
using a VLOOKUP. However, when the VLOOKUP finds a blank, it returns a zero. I want the chart to interpolate the data, but Excel charts can only interpolate blanks, not zeroes. I've used ISBLANK with the VLOOKUP to return what appears to be a blank, but the chart still sees it as a zero, and thus will not interpolate. I'd like to know if there's a way to set the value of a cell to NULL, because "" doesn't work... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
| Non Blank - Blank Cells???? | Excel Discussion (Misc queries) | |||
| I need a VLOOKUP to display 0 or blank instead of N/A | Excel Discussion (Misc queries) | |||
| Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) | |||
| Vlookup returns incorrect match | Excel Discussion (Misc queries) | |||
Threaded Mode
