excel - Index with counta and if?

Question

Another refresher for me with excel and index function. I am trying to pull the most recent data entry for a given construction task daily progress report. I have a calendar log for daily production on one sheet and am trying to populate "todays" data on the dashboard report that will always pull the last data entered for a given column. I need data from my "actual installed today" column to populate on the Daily Report sheet in the column labeled the same. But I am having problems with the index and counta/countif functions.

This is the current formula I have been trying to get to work and other variations I have tried.

=INDEX(E28:PX28,1,COUNTIF(E24:PX24, "Actual Installed For Today"))

标签： excel