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

 

[Fluff]

How about

=IF(COUNTIFS(C2:E16,A2),"contacted","Not contacted")

 

[Freeman2022]

How about

=IF(COUNTIFS(C2:E16,A2),"contacted","Not contacted")

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

Neither formula is working, It works in the numbers are on the same row, I'm trying to find all match regardless if the numbers are on the same row. Makes sense?

 

[Joe4]

You may need to change your range references, based upon what you actual ranges are:
=IF(COUNTIFS(C2:E16,A2),"contacted","Not contacted")

The range in blue is the value you are looking for.
The range in red is the range you are looking in for a match.
If you are copying this formula down for multiple values, then you will want to lock this range like this before copying your formula:
C$2:E$16

 

[Freeman2022]

You may need to change your range references, based upon what you actual ranges are:
=IF(COUNTIFS(C2:E16,A2),"contacted","Not contacted")

The range in blue is the value you are looking for.
The range in red is the range you are looking in for a match.
If you are copying this formula down for multiple values, then you will want to lock this range like this before copying your formula:
C$2:E$16

Hi,

Even with the formulas locked its not working, See in Yellow..Those should be Contacted

 

[Fluff]

It works in the numbers are on the same row

No it doesn't, it works if the value in A2 is anywhere in C2:E16

Fluff.xlsm
	A	B	C	D	E	F
1
2	90	1	65	21		contacted
3	3	2	37	32		contacted
4		90	55	87		Not contacted
5						Not contacted
6						Not contacted
7						Not contacted
8	32					contacted
9
10
11
12
13
14
15				3
Main

Cell Formulas
Range	Formula
F2:F8	F2	=IF(COUNTIFS($B$2:$D$16,A2),"contacted","Not contacted")

 

[Fluff]

You have highlighted 3 numbers in col A all of whcih say contacted in col F, so not sure what your problem is.

 

[Joe4]

Hi,

Even with the formulas locked its not working, See in Yellow..Those should be Contacted

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.

 

[Freeman2022]

No it doesn't, it works if the value in A2 is anywhere in C2:E16

Fluff.xlsm
	A	B	C	D	E	F
1
2	90	1	65	21		contacted
3	3	2	37	32		contacted
4		90	55	87		Not contacted
5						Not contacted
6						Not contacted
7						Not contacted
8	32					contacted
9
10
11
12
13
14
15				3
Main

Cell Formulas
Range	Formula
F2:F8	F2	=IF(COUNTIFS($B$2:$D$16,A2),"contacted","Not contacted")

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

 

[Fluff]

but it shows not contacted.

No it doesn't it shows Contacted in F2.
Which is what you asked for.