Advanced "Lookup/Match" formula

[Ckeller0111]

Please help. I am struggling with the formula needed. A9 always returns "today's" date. I need cell B9 to look for today's date in row 1 and return the results of how many loads remain (which auto count based upon the information entered in the selected day's columns). I cannot seem to get anything to work correctly. I have supplied a screenshot but had to black out customer information. 

 

 

[#2 · Accepted solution]

@Ckeller0111 

=OFFSET(INDEX($1:$1,MATCH(A9,$1:$1,0)),,8)

If the count of remaining loads is always 8 columns to the right of the date (in row 1) then you can try this formula.

 

[#3]

@OliverScheurich it worked you are phenomenal! Thank you so much!

[#4]

@Ckeller0111 

You are welcome. Glad my suggestion is helpful.