Index Match & #values
I am using an Index function, together with MATCH. The index refers to a separate workbook. The problem occurs when the INDEX imports data from 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 INDEX encountered a blank cell.
Is there anything I can do to overcome this issue? Maybe something to ignore the particular INDEX function if it returns a #VALUE result?
Thanks a lot,
Dan
|