0

I would like to compare two different GSheet files (NOT sheets within the same file) and return a cell value if three (or more) values match.

In File 1 ( https://docs.google.com/spreadsheets/d/1kYc6CuO_dSkxtKWpfGDmHuYiR2SLY-p8NanEgzTnDOA/edit#gid=0 ) I have the following columns:

Column A: Name

Column B: Last Name

Column C: Date of birth

Column D: Telephone number

In File 2 ( https://docs.google.com/spreadsheets/d/1gbnNbE2q0ayAQEAn1aUGIGD7Bc14GQ5FcK-74IjGUhU/edit#gid=0 ) I have:

Column A: Name

Column B: Last Name

Column C: Date of birth

Column D: to be filled with phone numbers from above

I would like a formula in Column D File 2 that compares the values of columns A, B, C in both files, and if there is a match, that paste the relevant value from Column D File 1 into Column D File 2.

I have worked out a formula that would work in two excels in the same folder but not in GSheet which is web based; the formula is the following:

=IFERROR(INDEX('[File 1.xlsx]Database'!$D$2:$D$11,MATCH(A2&B2&C2,'[File 1.xlsx]Database'!$A$2:$A$11&'[File 1.xlsx]Database'!$B$2:$B$11&'[File 1.xlsx]Database'!$C$2:$C$11,0)),"")

Thanks

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.