Do we need to use multiple criteria in XLookUp to prevent the function not to return the first matched Lookup value as VLookUp does?
Second question:
Which one is better approach for XLookUp with multiple criteria?
=XLOOKUP(B18&C18,$B$5:$B$15&$C$5:$C$15,$D$5:$D$15)
or
=XLOOKUP(1,($B$5:$B$15=B18)*($C$5:$C$15=C18),$D$5:$D$15)
Please advise me.
Regards,
BittenApple


