Match Row data horizontally

Question

Hello,

I have extracted data from two sources which is saved as Intake and Tax in the attachment. I am looking validate the conditions in the Validation sheet and give a output as Reject or proceed.

Basically need to compare the rows in Intake sheet & Tax sheet according to the conditions in the validation sheet.

Can anyone assist on  this, Some of the field name will not be the same. Example version will be only in Tax form.

Compare data.xlsx

Saravanan13 · Accepted Answer

Thank you so much Yoshiro, That worked. I have one question what logic did you use for "Proceed formula"

Yoshiro_Fujimori · Accepted Answer

@Saravanan13 ,

You mean the logic of this expression?

Proceed =

[is_2023] AND [match_First_Name] AND [match_Middle_Name] AND [match_Last_Name]

AND ![has_PO_Box] AND ![contains_US]

As all columns are in bool type,

when they are connected with "AND" operator, the result is TRUE only when all the values are TRUE.

In this case, you can interpret it as

The year is 2023

First Name matches

Middle Name matches

Last Name matches

does NOT have PO Box  // because the value is negated with "!" at the head

does NOT contain US   // because the value is negated with "!" at the head

I like using "is_" "has_" in bool type columns as described in the book "The Art of Readable Code" (P27 Naming Booleans).