INDEX(MATCH) Problem

Hello All,

I'm sorry I've posted the same thread in a wrong place, this is the right place for it I believe. Sorry!




I am a little lost since yesterday.

I've got a DataSheet where I enter data such as 'Date&Time', 'employee' and 'Service'.

On the other sheet I've got a monthly calendar and also date and drop-list for choosing 'employer' to show which dates he/she is working.

basically when I choose the employee, it matches the Name and The Dates and Times on the other sheet and returns me the value with this code

=IFERROR(INDEX(tblData;MATCH(C$5+$B10&ShowName;tblData[DATE & TIME]&tblData[WHO];0);3);"")

So it matches C$5+$B10 (which is date and time) & ShowName (name of the employee) with tblData[DATE & TIME] & tblData[WHO] and returns the 3rd column as the value.

this works perfect in this file;

alltimetable.xlsx

but in this 2nd file;

2- alltimetable.xlsx


when I wanted to change Data Entry information to make it more useful, it stopped giving me the results.

I can MATCH separately (as in ' Schedule all ' sheet)

like this :

=IFERROR(INDEX(DATA;MATCH(C$5+$B10;DATA[DATE & TIME];0);3);"")

or like this :

=IFERROR(INDEX(DATA;MATCH(ShowName;DATA[WHO];0);3);"")

but when I combine these together with ' & ' :

=IFERROR(INDEX(DATA;MATCH(C$5+$B7&ShowName;DATA[DATE & TIME]&DATA[WHO];0);6);"")

it stops giving a result.

I've cheked everything I can for the last 20 hours
And I am just out of moves....

Please help me out

Thanks in advance

did you array enter it with ctrl+shift+enter?
=IFERROR(INDEX(tblData;MATCH(C$5+$B10&ShowName;tblData[DATE & TIME]&tblData[WHO];0);3);"") is an array formula