Forum Discussion
Solved
Advanced "Lookup/Match" formula
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 co...
=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.
=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.
OliverScheurich it worked you are phenomenal! Thank you so much!
You are welcome. Glad my suggestion is helpful.
