If Statement search range of non-unique values

[xslim12]

Hey Guys,

I have a cell range of non-unique values and tickers to the cell on the right.

eg:

A B
1 1 AAPL
2 1 MSFT
3 1 (you get the rest)
4 1
5 2
6 2
7 2
8 3
9 3
10 4


I want to create a formula that can search column A and, for example, give me all the tickers categorized as 2. I am using a long offset function coupled with count and countif to solve this issue but its long and confusing. I would prefer a formula without VBA.

I was thinking an array =if(A:A=1,B:B."") would work but guess not.

Thanks.

 

[AhoyNC]

Something like this?

This is an array formula and must be entered with CTRL-SHIFT-ENTER.
copy formula down as needed.

Excel Workbook
	A	B	C	D
1	A	B	Find
2	1	AAPL	2	ddd
3	1	MSFT		eee
4	1	bbb		fff
5	1	ccc
6	2	ddd
7	2	eee
8	2	fff
9	3	ggg
10	3	hhh
11	4	iii
Sheet1

 

[xslim12]

That worked. Thank you!

 

[AhoyNC]

Your welcome. Thanks for the feedback and welcome to the forum.