Index Match formula issue

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.

The last parameter in a MATCH function is zero to say an exact match, not what to return if blank.

Try:

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


Regards, TMS

---------- Post added at 03:48 AM ---------- Previous post was at 03:47 AM ----------

Clearly no gold medal for me

If you're returning a text value (as opposed to a numeric value) you can add &"" to suppress a 0 result:

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

Just so you're clear: the IFERROR() suppresses an #N/A error when the reference cannot be found (as your first post says).
The &"" suppresses a 0 result when the reference is found but the associated cell is blank

EDIT: TMS - what are you doing still awake?? Waiting for the Mars landing??

@Cutter: mostly age related, the details of which, I will leave to your imagination (or experience). Plus, I'm working on a project and decided to rework the code. When I first put the code together, it was all related to one sheet. Then I needed to make some of it work on two sheets and some of it work on three sheets. It was meant to be generic but it isn't, hence the rework ... and some of the code is spinning round in my head, thus precluding sleep. Nice of you to notice

---------- Post added at 04:49 AM ---------- Previous post was at 04:41 AM ----------

@Cutter: the Mars landing is due in another hour and 40 minutes ... don't know if I can stay awake that long. We'll see.

---------- Post added at 05:29 AM ---------- Previous post was at 04:49 AM ----------

@Cutter: are you watching?

http://mars.jpl.nasa.gov/msl/participate/
http://mars.jpl.nasa.gov/msl/multimedia/nasatv/

You're welcome.