Advanced "Lookup/Match" formula

Copper 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. 






3 Replies
best response confirmed by Grahmfs13 (Microsoft)



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 

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


You are welcome. Glad my suggestion is helpful.