Matching Multiple Columns with Nulls

[Hayden_McHan]

I am trying to write a formula that will tell me if the ID numbers that are in 4 columns match each other when a value is present. So if only 2 of the columns have a value I want to know if those 2 match even though 2 of the columns have null values. Here is a preview of what the data looks like. Essentially I need something that says if the cell has a value compare that value to the value (if present) in the 3 other columns. 

Any ideas?

[afv2688 · Accepted solution]

Hello @Hayden_McHan ,

I created a little something for you to check.

Hope it helps.

Regards

[L_T · Accepted solution]

Hi, 

Let me know if this works!

[Hayden_McHan]

Thanks so much!! Worked great.

[Hayden_McHan]

Thanks so much!! Worked great. Appreciate it