Display value on cell according to values on other table/array (Reloaded)

[6tel]

Hi.

This is another version of a question I made too long ago...

I am building a calendar in the attached file.

You will find two (2) sheets in there:

1) One called "Matriz Nuevo Calendario" (where I will be feeding events from this year to the end of 2026)

2) And the other one titled "Dashboard", in which I will make my boss see events for the current month (in a sort of horizontal timeline)

At the "Dashboard" sheet, there is a row in which I list days of the current month (range "E4:AI4"), from the first day to the last: 1 to 31 (for months like february, april, june, september and november I will do a prior work not worth mentioning now)

Anyway, I need each cell from range "E5:AI5" in the Dashboard sheet to display the corresponding value from "C3:C1251" to its date from the "B3:B1251" range at the Matriz Nuevo Calendario sheet.

By this I mean:

Row 5 in the Dashboard sheet will display the name of the events listed in column C of the Matriz Nuevo Calendario sheet in an horizontal progression, but to its corresponding day (each date listed in row 4 in the Dashboard sheet will need to match dates on B column of the Matriz Nuevo Calendario sheet)

I tried following the logic on the answer Narayank991 gave me, but my knowledge is quite dusty and unused this time:

On E5:
=SI(ESERROR(COINCIDIR(Dashboard!E4;'Matriz nuevo calendario'!B3:B1251;0));"";INDICE('Matriz nuevo calendario'!C3:C1251;COINCIDIR(Dashboard!E4;'Matriz nuevo calendario'!B3:B1251;0)))

But it is not working for this cell and neither for the others in the same row (row 5, range "E5:AI5").

I don't seem to find a way to fix the formula in this new table arrangement I am proposing... It's been too long since I did something with this complexity (I never was an Excel expert).

Can someone help me?

 

[vletm]

6tel​

Something like this ...

 

[6tel]

Yes dear. Exactly like that! But I don't understand if there is some formatting issue not helping me.

At first I copy-pasted the whole range from your file (E5:AI5) to my Excel in OneDrive where I am working this calendar, but it seems doing this brought your local configuration to my file, I guess... Content in range E5:AI5 came right to left even after formatting my cells here after copying your formulas.



Then, I retried everything. And I copy-pasted again the whole range from your file (range E5:AI5) but it seems it just pastes results from your formulas (not the formulas per sé).



Finally, I copied the formula on cell E5 (Dashboard sheet) from your file, and I dragged it to cell AI5... The formula copied itself in series with its respective variations, but now it is bringing me an error.



It is a bit weird, because formulas are kept exactly like yours. I tried formatting E5:AI5 to "General" like in your file, but still the same issue.

Any ideas?

 

[vletm]

6tel​

#1 Check cell E4's formula ( gotta be date )
#2 Range E4:AI1 has Custom format ( show only dat )
#3 Of course this could do with
... eg VlookUp ... check cell E7
... with tables ... check cell E9 and E11
Other sample file too

 

[6tel]

Thank you so much, dear. I guess it was bullet #1, as it worked completely after correcting it.

And I Ioved the alternate options!

Many-many thanks.

 

[vletm]

If You're using dates then use ... dates.