Hi,

I have a formula that I am using to reference and apply a text entry to a cell if conditions are met. I want the formula to show a blank cell if the reference cannot be found. Rather than using 0 as the last entry in the Index Match formula syntax, I have tried "", and have also applied an Iferror to attempt to show the cell as blank if the value cannot be found. Unfortunately I can only seem to use zero in the syntax as the relevant text will not show up at all when the cell has the correct value to drive application of the text entry. As a result, I still get either the text entry or '0' showing up, when I only want a blank cell if the reference cannot be found. Appreciate any help.


=IFERROR(INDEX(Categorisation!E:E,MATCH(Data!Z18,Categorisation!F:F,"")),"")