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 image 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

 

[Sufiyan97]

Can you please post your data using below link so that helpers do not need to type everything manually

 

[Linda G]

Can you please post your data using below link so that helpers do not need to type everything manually

I'm sorry I don't think that i have access to that... i tried following the instructions and cannot find that add-in?

 

[Fluff]

How about

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

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Returning a value in a sheet based on current date and time
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Linda G]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Returning a value in a sheet based on current date and time
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

apologies again!

 

[Fluff]

Did the formula I posted work?

 

[Linda G]

Did the formula I posted work?

sorry i was just trying it! It did indeed, thank you. you sir, are a shining star!

 

[Fluff]

Glad we could help & thanks for the feedback.