Does A Value in Column A Exists in column B Yes/No should be in Column C

[maslam15]

Hello Everyone,
I am trying to find out the formula if the values I have in Column A Exists in Column B Should Say Yes/No in Column C. Please see an excel table below.

ID	ID2	Does ID in column A exist in Column B
112	112	Yes
111	115	No
113	114	Yes
114	113	Yes

Thank you,

 

[Fluff]

How about
=if(isnumber(match(a2,b$2:b$10,0)),"Yes","No")

 

[denzo36]

Hi try

={IF(OR(A2=$B$2:$B$5),"Yes","No")} - enter formula with Ctrl+Shift+Enter

 

[ahennema]

I just ran the above formula: IF(OR(A2=$B$2:$B$5),"Yes","No") and did not need the CTRL+SHIFT+ENTER, in fact it did not work with CTRL+SHIFT+ENTER

 

[denzo36]

You can enter the formula without ctrl+shift+enter but it will not work, you need to ctrl+shift+enter as it's an array formula. You may need to adjust your range for column B if it's larger than the range shown in your post.

The formula should be in column C2 and filled down. I did it here and it works fine

 

[Fluff]

If you have dynamic arrays, then you don't need to use CSE

+Fluff.xlsm
	A	B	C	D
1	D	ID2	Does ID in column A exist in Column B
2	112	112	Yes	Yes
3	111	115	No	No
4	113	114	Yes	Yes
5	114	113	Yes	Yes
Report

Cell Formulas
Range	Formula
C2:C5	C2	=IF(ISNUMBER(MATCH(A2,B$2:B$10,0)),"Yes","No")
D2:D5	D2	= IF(OR(A2=$B$2:$B$5),"Yes","No")

 

[maslam15]

Thank you everyone the formula worked for me

 

[Fluff]

Glad we could help & thanks fro the feedback