Index Match & #values

[DanielF]

I am using an Index function, together with MATCH. The index refers to
separate workbook. The problem occurs when the INDEX imports data fro
an empty cell.

From one sheet it simply displayed nothing (this is what I need).
When I've added an Index to this Index (meaning... INDEX function
another INDEX function) it returned #VALUE where the second INDE
encountered a blank cell.

Is there anything I can do to overcome this issue? Maybe something t
ignore the particular INDEX function if it returns a #VALUE result?

Thanks a lot,
Da