Hi All
I have a workbook which I am trying to link to another using INDEX MATCH.
The cells I am asking INDEX and MATCH to return have different values in them and some of them are blank. Some, but not all, of the blank cells are returning zeros rather than a blank cell.
I've tried to check the formatting of the cells to ensure they're all the same and they seem to be. I've also tried adding a conditional formatting rule using ISBLANK selecting the custom format category and entering a semicolon in the type field, but some of my cells are still returning zeros. Any ideas?
Thanks in advance
I have a workbook which I am trying to link to another using INDEX MATCH.
The cells I am asking INDEX and MATCH to return have different values in them and some of them are blank. Some, but not all, of the blank cells are returning zeros rather than a blank cell.
I've tried to check the formatting of the cells to ensure they're all the same and they seem to be. I've also tried adding a conditional formatting rule using ISBLANK selecting the custom format category and entering a semicolon in the type field, but some of my cells are still returning zeros. Any ideas?
Thanks in advance