How many people are away today? - Match dates and return corresponding value

[Matt_Straya]

Hi I am looking to return a value that matches today's date. I need to know how many staff are away based on today's date. I would really appreciate any help on this one.

 

[rbobcat1]

is this what you are looking for?

 

[AlanSidman]

If I am understanding your issue then, in AH3 type =INDEX(B4:AF4,MATCH(AH2,B5:AF5,0))

 

[Matt_Straya]

Perfect! thank you! and just in time for the report to the boss

 

[AlanSidman]

Perfect! thank you! and just in time for the report to the boss

and who are you thanking? Which solution worked for you?