Forum Discussion
Counting only if an item appears in both columns that are on different spreadsheets
I need to check if a product on one spreadsheet matches with a product code matches with the product codes on another spreadsheet. Therefore, I need a formula that allows spreadsheet names and multiple variables that need to be checked against all at the same time.
- Check out the XMATCH function. If it finds a match, it returns a number (the relative row or column the match is on), if not it returns #N/A or whatever result you ask it to return when there is no match.
