Xlookup Help to produce a number if not found on prior tab Hello Community,

I am looking for some help and I'm sure someone here knows. I am new to the Xlookup formula and I am trying to return a formula if result is not found.

So, currently it sits as: =xlookup(d4,'2024'!D,'2024'!B:B, "not found",

That works and returns "Not Found" when it...
https://www.excelforum.com/sho....wthread.php?t=142173