SOLVED

Advanced "Lookup/Match" formula

New Contributor

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. 

 

 

20220711_132032.jpg

20220711_133101.jpg

 

3 Replies
best response confirmed by Grahmfs13 (Microsoft)
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.

remaining loads.JPG 

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

@Ckeller0111 

You are welcome. Glad my suggestion is helpful.