Find the most recent entry in a table

Hi all,

I have a formula (TEMPLATE O247)

=IFNA(XLOOKUP(1,('IT0015'!$A:$A=$B$1)*('IT0015'!$X:$X=J252),('IT0015'!$Z:$Z)),0)

I want to add that if the "Changed On" date is between Nov 1 & 15th to use the amount but if it's not, leave as 0

for (TEMPLATE O249)

=IFNA(XLOOKUP(1,('IT0014'!$A:$A=$B$1)*('IT0014'!$X:$X=J254),('IT0014'!$Z:$Z)),0)

if IT0014 has an end date of 9999-12-31 OR start/end dates are between Nov 1-15 then return that value but if it's not, leave as 0

O247

Formula:

Please Login or Register  to view this content.

O249

Formula:

Please Login or Register  to view this content.

Or can try

O247

Formula:

Please Login or Register  to view this content.

O249

Formula:

Please Login or Register  to view this content.

@RhiSJ

Worked perfectly!! May I throw another variable in? Nov 1-16 is PP 22-2024 (A214:A273). How do we adjust the date look up so when I copy down to PP 23-2024 (A274:A325), it takes Nov 16-30 without manually adjusting the formula dates?

P247

Formula:

Please Login or Register  to view this content.

p249

Formula:

Please Login or Register  to view this content.

@shukla.ankur281190

This one worked better in my live workbook Thank you