Forgot a formula

[mduntley]

For some reason, i am forgetting to do a formula in Excel 365. I simplify my workbook to show on this page. I am trying to find F2 in column c, and only return a true value.

Look Morty, I am a excel table
	A	B	C	D		F	G
1	id #	procedure external id	X			New Sheet
2	74	720000022	96367			96367	720000022
3	74	921000007	93925				FALSE
4	74	921000008	93926				FALSE
5	74	940000017	96367				940000017
Sheet3

Cell Formulas
Range	Formula
G2:G5	G2	=IF(F2=C2:C5,B2:B5)
Dynamic array formulas.

 

[Fluff]

Do you mean you want to return all values from B if C =F2?

 

[mduntley]

Yes. This is what i want

all.xml
	F	G
1	New Sheet
2	96367	7.2E+08
3		9.4E+08
4
5
Sheet3

 

[Fluff]

In that case, try

=FILTER(B2:B5,C2:C5=F2,"")

 

[mduntley]

Crap, I forgot to include something. I need to filter include the 74. This is the updated table

all.xml
	A	B	C	D	E	F	G	H
1	id #	procedure external id	X			id #	New Sheet
2	74	7.2E+08	96367			74	96367	7.2E+08
3	74	9.21E+08	93925					9.4E+08
4	74	9.21E+08	93926
5	74	9.4E+08	96367
Sheet3

 

[Fluff]

Ok, how about

=FILTER(B2:B5,(C2:C5=G2)*(A2:A5=F2),"")

 

[mduntley]

That does work, but I am wondering if my table is to big for the filter function. the table array that i am doing is 35,000+ rows and all of the result is returning as a n/a

 

[Fluff]

Do you mean you are getting a #N/A error?

 

[mduntley]

Yes, i am getting a #N/A Error.

 

[Fluff]

In that case your data probably has #N/A errors in it, as that formula will not return that error otherwise.