Excel how to get matching column name in a table.

[gimmic]

Hi everybody
Could someone please help me about my problem?
I have a table that distributes job load daily. (For example 10 units for job A distributed to DAY 1 and DAY 2)
I want to find the day name which job A is already finished.
Day 3 for Job A
Day 4 for job B
Day 5 for job C

I really appreciate if someone can help me to formulate.
Thank you

 

[bosco_yip]

In C5, copied down :

=LOOKUP(9^9,1/D5:Z5,E$4:AA$4)

 

[gimmic]

In C5, copied down :

=LOOKUP(9^9,1/D5:Z5,E$4:AA$4)

View attachment 67686

Thank you so much. Works perfect.