XLOOKUP - MULTIPLE CRITERIA

[meppwc]

Is there a way to make XLOOKUP look for two different values in two different columns and return "YES" "NO" ?
Example:
XLOOKUP formula will reside in cell C2 of the "Asset Listing" worksheet
On the Asset Listing worksheet, search on the value in cell A2 in both columns F and H of the "Table" worksheet
Then
On the Asset Listing worksheet, search on the value in cell B2 in both columns F and H of the "Table" worksheet
RESULT EXPECTED:
If either value is found in either column, return "YES", if not found return "NO"

 

[Eric W]

Try:

=IF(SUM(COUNTIF(Table!F:F,A2:B2),COUNTIF(Table!H:H,A2:B2)),"YES","NO")

 

[meppwc]

That did it............thanks Eric

 

[Eric W]

Glad to help. Thanks for the feedback.