INDEX(MATCH) Problem

[strangedenial]

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

Please Login or Register  to view this content.

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 :

Please Login or Register  to view this content.

or like this :

Please Login or Register  to view this content.

but when I combine these together with ' & ' :

Please Login or Register  to view this content.

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

[martindwilson]

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

[strangedenial]

Oh my god!

Why does the obvious always take the most time to figure out ?

I really turned red now

Thanks

[strangedenial]

Oh my god!

Why does the obvious always take the most time to figure out ?

I really turned red now

Thanks