Using result as row number

[Luke777]

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.

 

[Fluff]

Maybe

=XMATCH(A3,TAKE(DROP(Sheettest!A:A,XMATCH(NOW(),Sheettest!A:A)-1),36))