Matching Formula Problem

[MikeRob]

I'm having a tough time with this and think I'm very close but cant quite get the. i was trying if statements, index match, but cant get it to quite work.
here's what I'm trying to do in column a the letters appear in sets of 5, and in column b, the letters appear 1 each. how can I achieve the result where in column c a value od 1 is returned in column c's cells because they match column b?

see image:

a	a	1​		how to get c 1-5 to return 1 cause they match b
a	b	1​		how to get c 6 - 10 to return 1 cause they match b2
a	c	1​		how to get c 11 -15 to return 1 cause they match b3
a	d	1​		how to get c 16 - 20 to return 1 cause they match b4
a		1​
b		1​
b		1​
b		1​
b		1​
b		1​
c		1​
c		1​
c		1​
c		1​
c		1​
d		1​
d		1​
d		1​
d		1​
d		1​

 

[Peter_SSs]

That isn't entirely clear to me. Is this the sort of thing you mean?

20 10 29.xlsm
	A	B	C
1	a	a	1
2	a	c	1
3	a		1
4	b
5	b
6	b
7	c		1
8	c		1
9	c		1
MikeRob

Cell Formulas
Range	Formula
C1:C9	C1	=IF(ISNUMBER(MATCH(A1,B:B,0)),1,"")

 

[MikeRob]

That isn't entirely clear to me. Is this the sort of thing you mean?

20 10 29.xlsm
	A	B	C
1	a	a	1
2	a	c	1
3	a		1
4	b
5	b
6	b
7	c		1
8	c		1
9	c		1
MikeRob

Cell Formulas
Range	Formula
C1:C9	C1	=IF(ISNUMBER(MATCH(A1,B:B,0)),1,"")

Solid... it worked like a charm!!! thank you ever so much for your help. I’ll be sure to give you a thumbs up and a follow... thank you for your help I really appreciate! it I’ll be sure to come to you as well for any more questions or problems I may need solved!

 

[Peter_SSs]

Solid... it worked like a charm!!! thank you ever so much for your help. I’ll be sure to give you a thumbs up and a follow... thank you for your help I really appreciate!

You're welcome. Thanks for the follow-up.
If you choose, since a recent forum upgrade, you can now also mark a particular post as the solution by clicking the tick mark at the top right of that post.

I’ll be sure to come to you as well for any more questions or problems I may need solved!

You will need to just post in the forum again, rather than "come to me" specifically.