Hey all,

​

So I'm using the following formula:

=XLOOKUP(MAX(Purchases[Purchase_Date]),(Purchases[First Name]=C23)*(Purchases[Purchase_Date]),Purchases[Package_ID],"Renewal Required",-1)

trying to find the most recent package/purchase ID for a given name (the name in C23). This formula is working in every cell, but when I have a name that doesnt exist within the purchases table, the formula is returning 1 instead of an error or "Rewnewal Required".

​

The 1 is coming from the very first row in the purchases table under the package_ID column. I'm not sure understanding why its defaulting to that first value instead of throwing an error like it should be.

​

Thanks :)