lookup data based on column header

[c_shelby1030]

Hi All,  

I have a maser schedule that I will be using to build daily schedules from.  There are dates as column headers and employees names at the beginning of each row.  What I wanted to do is enter a date and shift, then have excel look in that specific column for the shift listed and return the employees name on the far right. For some reason I have not been able to get the index - match to pull the correct name.  

I am using Excel 2016

[#2 · Accepted solution]

@c_shelby1030 

Use

=INDEX(A8:A17,MATCH(B2,INDEX(B8:AE17,0,MATCH(B1,B7:AE7,0)),0))

[#3]

Thank you so much, works perfectly!!! This has been driving me crazy!!!

[#4]

@c_shelby1030 

Another possible formula:

=INDEX(A:A,SUMPRODUCT((B7:AE7=B1)*(B8:AE17=B2)*ROW(A8:A17)))