Compare 3 columns in excel

[Freeman2022]

Hello,

I have a list of numbers in column A listed as Customer numbers, also in columns C,D,E are customer numbers. What I'm trying to do is if Column A info is found in column C,D or E, then Column F is Contacted, if not then not contacted.

Thanks in advance

I'm using excel 365

 

[Joe4]

90 is in Column A and Column C, but it shows not contacted.

Sure it does.
"90" appears in cell A2.
So in column F2 it shows "contacted"

Note that the formula in column F applies to column A of the same row (row 2).
So F2 applies to A2.

If you want it to work any other way, you need to explain it in more detail, as it is not clear to us.

 

[Freeman2022]

Looks like it is working just fine to me.

Note that the formulas you are placing in column F are looking up the values in column A OF THE SAME ROW in the entire range in columns C-E.
If that is not what you want, then you need to explain in more detail.

Right, I indicated that the numbers might not be in the same row, if the info in column A is found on any row C-E it should be Contacted. Does that help?

 

[Fluff]

if the info in column A is found on any row C-E it should be Contacted.

But that is exactly what the formula is doing, if the value in A is found, then that row in col F is marked as contacted.

 

[Freeman2022]

But that is exactly what the formula is doing, if the value in A is found, then that row in col F is marked as contacted.

Oh ok yes, then I said it backwards, sorry about that, if the values in Column C-E are found anywhere in Column A, it should say contacted. If columns C-E does NOT contain a number in Column A, then it should say NOT Contacted.. Column F should be driven by C-E. So sorry about that

 

[gargamalebarbosa]

Hi, is this ok for you ?

 

[Joe4]

Hi, is this ok for you ?

View attachment 70948

I am pretty sure that will not work for them, as that is only checking cell A2 and not all of column A.

I think they need a formula like this in F2:

=IF(COUNTIF(A:A,C2)+COUNTIF(A:A,D2)+COUNTIF(A:A,E2)>0,"contacted","not contacted")

 

[Fluff]

if the values in Column C-E are found anywhere in Column A

But how would you know which of them had been contacted?

 

[Freeman2022]

I am pretty sure that will not work for them, as that is only checking cell A2 and not all of column A.

I think they need a formula like this in F2:

=IF(COUNTIF(A:A,C2)+COUNTIF(A:A,D2)+COUNTIF(A:A,E2)>0,"contacted","not contacted")

PERFECT!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! This works....Thank YOU SO MUCHHHHHHHHHHHHHHHHHHHHHHHHHHHH

 

[Fluff]

@gargamalebarbosa that's the same formula I supplied in post#2, which the OP said didn't work.

 

[Joe4]

PERFECT!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! This works....Thank YOU SO MUCHHHHHHHHHHHHHHHHHHHHHHHHHHHH

You are welcome.
Glad we were able to help.