you can try to evaluate it first using if

=if(INDEX(Categorisation!E:E,MATCH(Data!Z18,Categorisation!F:F,0))="","",INDEX(Categorisation!E:E,MATCH(Data!Z18,Categorisation!F:F,0)))
hth.