Returning a value in a sheet based on current date and time

[Linda G]

I have a sheet that tracks deployment of vehicles during each day on an hourly basis. (please see example file below)

I really want to automate the status in cell D1 based on the current date and time (held in G1) from the data below so that the status is always current without having to be updated each time.

Could someone please suggest a formula to solve this problem as I am really not sure how to do that....

Many thanks in advance

[Linda G]

thank you, this issue has been solved on the mr excel website (i would post a link but im not allowed!)

[FDibbins]

thank you, this issue has been solved on the mr excel website (i would post a link but im not allowed!)

Thanks for the update - would you please share what the solution was.

[Linda G]

Yes.. I was given the following formula which works perfectly

=INDEX(D8:AA26,MATCH(INT(G1),B8:B226,0),MATCH(MOD(G1,1),D7:AA7,1))

[FDibbins]

Thank you, Im sure that will help others, too