CODEWITHSUNDEEP
if-statementgoogle-sheetsgoogle-sheets-formula
user16239103
user16239103

Reputation:

Check match between two sheets in Google Sheets

I'm trying to compare values from one sheet to another and see the comparison of this in a third one. Let me share some values:

Data sheet 1:

Institution name    Management  Radiology   Nuclear number  Pathology   Laboratorie Systemic    Pediatric   Radiotherapy    Surgery Palliative
Institute 1           Log in    Log in      Not Completed   Log in      Log in      Log in      Log in      Completed       Log in
Institute 2       Not Completed Completed   Not Completed   Not Completed   Log in  Log in      Log in     Not Completed  Completed Completed
Institute 3     Not Completed   Not Completed   Log in      Completed   Completed   Log in      Log in     Completed

Data sheet 2:

Institution name    Management  Radiology   Nuclear number  Pathology   Laboratorie Systemic    Pediatric   Radiotherapy    Surgery Palliative
Institute 1       Not Completed Not Completed   Completed   Not Completed   Not Completed   Not Completed       Not Completed   Completed   Not Completed
Institute 2       Not Completed Completed   Completed   Not Completed    Not Completed   Not Completed  Not Completed   Completed   Not Completed   Not Completed
Institute 3    Not Completed    Not Completed   Not Completed   Not Completed   Not Completed   Not Completed       Not Completed   Not Completed

As we see in a few ones they match completed but in the ones that do not match I want two things in the logic:

I have my Google sheet Document with the full data and the desirable result in the sheet "doublecheck". Help please

Upvotes: 0

Views: 126

Answers (1)

muw
muw

Reputation: 385

I think you are looking for a formula like this:

=ARRAYFORMULA(
IF(
(((Track!B2:K20="Completed")*(submission!B2:K20="Completed"))=1)+(submission!B2:K20="Completed")>0;
"Completed";
Track!B2:K20))

For clarification on the logical expression please refer to this answer.

Link to Google Sheet

Upvotes: 0

Related Questions