Dynamic search and filter formula

[Newbienew]

I am looking for a dynamic formula that will search a column for specific numbers and the names attached to them. It would be like a unique value vlookup automated filter. It will have to be based on the code as names will be added to the code, and I can use a helper sheet with the codes in case of code changes. There are duplicate names, but these names are attached to different codes. I am looking to set this up due to the code and names appearing multiple times on another sheet, and manual entry needs to be reduced. Thank you for your assistance in advance

Column B	Column C
320711	Name1
320712	Name2
320712	Name3
320713	Name3
320715	Name5
320715	Name6
321701	Name7
321711	Name8
321711	Name9
321711	Name10
321712	Name11
321712	Name10
321713	Name13
321713	Name14
321713	Name15
321713	Name7
322711	Name17
322712	Name18
322712	Name19
322712	Name20
322714	Name21
322714	Name22
322715	Name23
322715	Name24
322717	Name25
322718	Name24
322719	Name27
323711	Name28
323711	Name29
323712	Name30
323712	Name31
323712	Name32
323713	Name33
323713	Name34
323713	Name35
324701	Name36
324701	Name37
324701	Name38
324711	Name36
324712	Name40
324713	Name41
324713	Name42
324713	Name43
324716	Name44
324718	Name38
325701	Name46
325711	Name47
325711	Name48
325711	Name57
325711	Name50
325721	Name51
325721	Name52
325721	Name53
325721	Name54
325721	Name55
325731	Name56
325731	Name57
325731	Name58
325731	Name59
325741	Name60
325741	Name61
325741	Name62
325741	Name63
325751	Name64
325751	Name65
325751	Name66
325751	Name67
327712	Name68
327712	Name69
327713	Name70
327713	Name71

 

[Newbienew]

Yes. This is what I am looking to achieve ut based on a helper column. I was going to take column B place it on a separate sheet for all the codes the formula would need to search for. In your newest rendition I see you mentioned you couldn't do it without the number. If there were a helper sheet with the same codes will the code work. As the mention before the main sheet has a lot more codes and these ones pertain to my records.

 

[Eric W]

The B:C columns have to remain the same. The number must stay associated with the name. But I did think of a way to do it without the helper column:

Book1
	A	B	C	D	E	F	G
1		320711	Name1				Name
2		320712	Name2				Name1
3		320712	Name2				Name2
4		320713	Name3				Name3
5		320715	Name5				Name5
6		320715	Name6				Name6
7		321701	Name7				Name7
8		321711	Name8				Name8
9		321711	Name9				Name9
10		321711	Name10				Name10
11		321712	Name11				Name11
12		321712	Name10				Name10
13		321713	Name13				Name13
14		321713	Name14				Name14
15		321713	Name15				Name15
16		321713	Name7				Name7
17		322711	Name17				Name17
18		322712	Name18				Name18
19		322712	Name19				Name19
20		322712	Name20				Name20
21		322714	Name21				Name21
22		322714	Name22				Name22
23
Sheet2

Cell Formulas
Range	Formula
G2:G23	G2	=IFERROR(INDEX(C:C,AGGREGATE(15,6,ROW(C$1:C$22)/((ROW($B$1:$B$22)-ROW($B$1)+1)=MATCH($B$1:$B$22&"|"&$C$1:$C$22,$B$1:$B$22&"|"&$C$1:$C$22,0)),ROWS(G$2:G2))),"")

Edit: FYI, this is how it could be done in Excel 365:

=INDEX(UNIQUE(B1:C22),0,2)

 

[Newbienew]

Sorry for getting back to you late. I have been trying to implement your formula into the project for a few days. Which your formula is great by the way. I believe what I am trying to accomplish is more complicated than expected as I'm trying to implement this between 3 sheets.