Hi,
I’m doing something obvious wrong again. Below is my formula.
=MATCH(A3,A ??? MATCH(NOW(),'Sheettest!A:A)):MATCH(NOW(),'sheettest!A:A)+36)
Where the “???” Is, I’m attempting to use the result of the following match to set the lookup array for the first match.
As it stands, the 2nd match equals 2
And the 3rd match = 2+36
Both of which will change with the date but remain relative to each other.
Thanks.
I’m doing something obvious wrong again. Below is my formula.
=MATCH(A3,A ??? MATCH(NOW(),'Sheettest!A:A)):MATCH(NOW(),'sheettest!A:A)+36)
Where the “???” Is, I’m attempting to use the result of the following match to set the lookup array for the first match.
As it stands, the 2nd match equals 2
And the 3rd match = 2+36
Both of which will change with the date but remain relative to each other.
Thanks.