Matching numbers in two arrays and displaying text

[LookingForExcel]

I am looking to create a formula that would be able to identify if there was a match in an array and if there was then display "Orange" and if there was no match to display "Green"

For example

Array 1	Text		Array 2
1357	orange		1357
3478	green		5789
5789	orange		1437
1788	green
1437	orange

Any help is appreciated, thank!

 

[JoeMo]

Book1
	A	B	C	D
1	Array 1	Text		Array 2
2	1357	orange		1357
3	3478	green		5789
4	5789	orange		1437
5	1788	green
6	1437	orange
Sheet1

Cell Formulas
Range	Formula
B2:B6	B2	=IF(ISNA(MATCH($A2,$D$2:$D$4,0)),"green","orange")

 

[Phuoc]

Bieu gio-R1 (1).xlsx
	A	B	C	D
1	Array 1	Text		Array 2
2	1357	Orange		1357
3	3478	Green		5789
4	5789	Orange		1437
5	1788	Green
6	1437	Orange
Sheet2

Cell Formulas
Range	Formula
B2:B6	B2	=IF(COUNTIF($D$2:$D$4,$A2)=0,"Green","Orange")

 

[LookingForExcel]

Hi @JoeMo @Phuoc! Thanks so much for your help on that I really appreciate it. I've run into a more complex problem that I think can be fixed just by building off of previous formulas. Listed below is an example.

I'm working with zipcodes here, I want to know if the zip code is a primary zip code (orange) or a secondary zip code (yellow), and if it is not either of those to display a separate color (green). Based on that information to display a corresponding color.

A	B	C	D	E
All zipcode	color		Primary Zipcode	Secondary Zipcode
112233	orange		112233	223344
223344	yellow		678678	378378
567567	green		454545	876543
454545	orange		182731	674532
378378	yellow		832145	793134

Is it possible?

 

[Fluff]

How about

=IF(COUNTIFS($D$2:$D$6,A2),"Orange",IF(COUNTIFS($E$2:$E$6,A2),"Yellow","Green"))

 

[LookingForExcel]

Thank you for that @Fluff ! I'm just curious, would it be possible to add to that equation to include a third set of zip codes and display another color accordingly? I'm trying to understand if that would be possible or how to add onto the formula you listed above.

All zipcode	color		Primary Zipcode	Secondary Zipcode	Third set of Zipcodes
112233	orange		112233	223344	888555
223344	yellow		678678	378378	787431
567567	green		454545	876543	674284
454545	orange		182731	674532	543121
378378	yellow		832145	793134	111222
888555	blue

In this set there is a new column and the last zipcode in "All zipcode" is a match with the first zipcode in the "third set of zipcodes" column and displays the word "blue". Sorry for this addition but I was not anticipating this many sets of data.

 

[Fluff]

Try

IF(COUNTIFS($D$2:$D$6,A2),"Orange",IF(COUNTIFS($F$2:$F$6,A2),"Blue",IF(COUNTIFS($E$2:$E$6,A2),"Yellow","Green")))