Forum Discussion
bepsky
Jun 17, 2019Copper Contributor
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 ...
SergeiBaklan
Jun 17, 2019Diamond Contributor
For such sample
it could be
=IF(ISNUMBER(MATCH(1,INDEX((Sheet1!$A:$A=$A2)*(Sheet1!$B:$B=$B2)*(Sheet1!$C:$C=$C2),0),0)),"Yes","No")