Generating a True or False (Advanced!)

[brian8989]

Hi Experts,

Kindly refer to the queries and photo below:

I wish to generate a "True or False" result (column I). For example, cell H3 has a number 10, and cell H4 has a number 2, i would like to have a formula to generate True of False:

If the number in cell H3 (10) is in column A , then check if the number in cell H4 (4) is in Row 12, if
NO = False, Yes = True


https://ibb.co/4SKpR8t

 

[Fluff]

Yes but the image you showed is (IMO) correct.
If that is not what you want you need to explain why.

 

[brian8989]

Yes but the image you showed is (IMO) correct.
If that is not what you want you need to explain why.

Oh~Oppss...I am truly sorry that the result which you saw in the screenshot was not generated by formula, I just simply manually key in True or False, really sorry about the confusion created.

 

[Fluff]

How about

Book1
	A	B	C	D	E	F	G	H	I
2	0	3	5	7	9	11
3	1	4	6	8	10	12		10
4	2	5	7	9	11	13		2	TRUE
5	3	6	8	10	12	14		7	TRUE
6	4	7	9	11	13	15		4	FALSE
7	5	8	10	12	14	16		15	TRUE
8	6	9	11	13	15	17
9	7	10	12	14	16	18
10	8	11	13	15	17	19
11	9	12	14	16	18	20
12	10	13	2	17	19	21
Sheet1

Cell Formulas
Range	Formula
I4	=ISNUMBER(MATCH(H4,INDEX($A$2:$F$12,MATCH(H3,$A$2:$A$12,0),0),0))

 

[brian8989]

@Fluff WOW! This works great! Thank you so so so so much! Truly appreciate it!

/Solved

 

[Fluff]

You're welcome & thanks for the feedback