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
Discover the world at Altruu, The Discovery Engine