Forum Discussion

Copper Contributor

Jun 17, 2019

Excel Formula Help - Cross Referencing Two Spreadsheets

I'm looking to build a formula that will essentially get two spreadsheets in-sync. Both spreadsheets contain vast entries/rows that have "Names", "Dates" & "Types". I would like to build a formula ...

developer

excel

Excel Online

Formulas and Functions

training

Twifoo

Silver Contributor

Jun 19, 2019

bepsky

In the attached file, the formula in Sheet2!D2 is:

=IF(COUNTIFS(Sheet1!A:A,A2,
Sheet1!B:B,B2,
Sheet1!C:C,C2),
"Yes","No")

The foregoing formula counts the instances when the 3 conditions are met and returns "Yes" if the count is 1 or more; otherwise, it returns "No".

Countifs.xlsx10 KB