Return Records if a match is found

[agentkramr]

i have two columns in a spreadsheet that contain zipcodes column H has the criteria zipcodes, Roughly 214 but could expand to significantly more column G is the zipcodes i need to search through and only return the ones that match column H. column G has about 120k entries .. of course column A B C D E F have other customer info.

how would i go about only showing the rows that have a zipcode match to column H
conditional formatting didnt seem to work i tried and =IF and got some weird results
Excel 365

 

[DanteAmor]

It seems like you could use an advanced filter, but with your explanation I can't see how your data is, how to put the advanced filter and where to put the result.
You could give an example of how your data is and how you want the result. You can put dummy data.

Observe in the following thread how the OP put his examples in detail and also explained how he wanted the result. That will be easier to help.

extract data from the lastrow contains specific word based on date today

Hello I want to extract data for specific information with the formatting as in original sheets as I did it in REPORT sheet I want to extract for the DATE and INV.NO,TOTAL from each row contains SUM word based on date today . so in REPORT sheet should create sheet name in above as I did it...

www.mrexcel.com

Note: XL2BB

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in​

​

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.​

 

[agentkramr]

It seems like you could use an advanced filter, but with your explanation I can't see how your data is, how to put the advanced filter and where to put the result.
You could give an example of how your data is and how you want the result. You can put dummy data.

Observe in the following thread how the OP put his examples in detail and also explained how he wanted the result. That will be easier to help.

extract data from the lastrow contains specific word based on date today

Hello I want to extract data for specific information with the formatting as in original sheets as I did it in REPORT sheet I want to extract for the DATE and INV.NO,TOTAL from each row contains SUM word based on date today . so in REPORT sheet should create sheet name in above as I did it...

www.mrexcel.com

Note: XL2BB

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in​

​

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.​

here is the test data H is my column of zipcodes so if there is a matching zipcode in column G i only want to show the ones that match

Test.xlsx
	G	H
1	47022	24248
2	38260	24281
3	32095	28701
4	46205	28702
5	48040	28704
6	24630	28707
7	42732	28708
8	43011-9633	28712
9	70394	28713
10	24162	28715
11	45872	28716
12	30350	28717
13	28677	28719
14	43402	28721
15	31312-5606	28723
16	95207	28725
17	34787	28728
18	37862	28733
19	40356	28734
20	38343	28736
21	34210	28738
22	18643	28741
23	42001	28742
24	23320	28743
25	49090	28744
26	40356	28745
27	24502	28747
28	14850-9352	28748
29	43082	28751
30	43016-6180	28753
31	97146	28754
32	21678	28759
33	46123	28763
34	45601	28768
35	46732	28771
36	19526	28772
37	23434	28774
38	32162	28775
39	43804	28776
40	24528	28779
41	44685	28781
42	11942	28783
43	44718	28785
44	37863	28786
45	58784	28787
46	5482	28788
47	37143	28789
48	40241	28801
49	30014	28802
50	75704	28803
51	35504	28804
52	N7M 0R9	28805
53	37160	28806
54	15108	28810
55	32927	28813
56	28779	28814
57	24091	28815
58	61231	28816
59	30052	28901
60	62052	28902
61	25535	28904
62	77351	28905
63	45503	28906
64	40383	28909
65	48301	30525
66	46062	30537
67	37043	30546
68	74012	30562
69	30549	30568
70	34669	30582
71	29302	37314
72	48413	37329
73	35952	37333
74	61884	37354
75	35763	37385
76	37701	37616
77		37641
78	37129	37657
79	47243	37681
80	37804	37701
81	34480	37705
82	43231	37707
83	25535	37708
84	30641	37709
85	49224	37710
86	53027	37711
87	39771	37713
88	32908	37714
89	98367	37715
90	29349	37716
91	42633	37717
92	12047	37719
93	30068	37721
94	25901	37722
95	37725	37724
96	33834	37725
97	45424	37727
98	37135	37729
99	74104	37730
100	37777	37731
101	37075	37737
102	38305	37738
103	46037	37742
104	13207	37743
105	50009	37744
106	40218	37745
107	41008	37748
108	48187	37752
109	43062	37753
110	27712	37754
111	28791	37756
112	37064	37757
113	29330	37760
114	33020	37763
115	44011	37764
116	54126	37765
117	42724	37766
118	47265	37769
119	39305	37771
120	54902	37772
121	45238	37773
122	37922	37774
123	11791	37777
124	30813	37778
125	20657	37779
126	40342	37801
127	40437	37802
128	32764-9709	37803
129	29742	37804
130	47542	37806
131	39110	37807
132	00000	37809
133	28209	37810
134	38257	37811
135	35541	37813
136	29644	37814
137	41083	37815
138	30540	37816
139	39428	37818
140	30554	37820
141	30540	37821
142	29645	37822
143	23883	37824
144	30506	37825
145	89506	37826
146	34282	37828
147	23236	37830
148	72032	37831
149	38460	37840
150	43147	37843
151	48836	37845
152	35962	37846
153	35611	37848
154	28601	37849
155	36272	37851
156	28429	37853
157	28152	37857
158	28637	37860
159	32779	37861
160	32779	37862
161	95776	37863
162	24210	37864
163	53959	37865
164	78130	37866
165	40503	37867
166	40065	37868
167	30157	37869
168	46224	37870
169	45426	37871
170	37774	37874
171	77399	37876
172	40336	37877
173	40517	37878
174	30671	37879
175	44053	37881
176	20105	37882
177	37764	37885
178	47040	37886
179	49082	37887
180	30534	37888
181	11040	37890
182	21769	37891
183	49838	37901
184	29571	37902
185	35406	37909
186	28226	37912
187	34119	37914
188	38401	37915
189	34984-3640	37916
190	36861	37917
191	45011	37918
192	43772	37919
193	47561	37920
194	40330	37921
195	42539	37922
196	15083	37923
197	16947	37924
198	33182	37927
199	11691	37928
200	00778	37929
201	48374	37930
202	29715	37931
203	11731	37932
204	37923	37933
205	47036	37934
206	28640	37938
207	24639	37939
208	70526	37940
209	47393	37950
210	77632	37995
211	70607	37996
212	36346	37997
213	41501	37998
214	46952	40965
PATALISTE-1778960-20240919

 

[DanteAmor]

To open the Advanced Filter dialog box, click Data > Advanced.

In List range $A$1:$H$214. Change 214 to the last row with data in column G.

In Criteria range $H$1:$H$214. Change 214 to the last row with data in column H.

Press Ok, the result will be in columns J to P and down.

Ex:
Note: Notice that the headings of G1 and H1 are the same.
Before Advanced Filter:

varios 20sep2024.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	A	B	C	D	E	F	ZIP CODE	ZIP CODE
2	A2	B2	C2	D2	E2	F2	38260	24281
3	A3	B3	C3	D3	E3	F3	32095	28701
4	A4	B4	C4	D4	E4	F4	46205	28702
5	A5	B5	C5	D5	E5	F5	48040	28704
6								32095
7								46205
8
Hoja3

After Advanced Filter:

varios 20sep2024.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	A	B	C	D	E	F	ZIP CODE	ZIP CODE		A	B	C	D	E	F	ZIP CODE
2	A2	B2	C2	D2	E2	F2	38260	24281		A3	B3	C3	D3	E3	F3	32095
3	A3	B3	C3	D3	E3	F3	32095	28701		A4	B4	C4	D4	E4	F4	46205
4	A4	B4	C4	D4	E4	F4	46205	28702
5	A5	B5	C5	D5	E5	F5	48040	28704
6								32095
7								46205
8
Hoja3

 

[agentkramr]

To open the Advanced Filter dialog box, click Data > Advanced.

In List range $A$1:$H$214. Change 214 to the last row with data in column G.

In Criteria range $H$1:$H$214. Change 214 to the last row with data in column H.

View attachment 117139


Press Ok, the result will be in columns J to P and down.

Ex:
Note: Notice that the headings of G1 and H1 are the same.
Before Advanced Filter:

varios 20sep2024.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	A	B	C	D	E	F	ZIP CODE	ZIP CODE
2	A2	B2	C2	D2	E2	F2	38260	24281
3	A3	B3	C3	D3	E3	F3	32095	28701
4	A4	B4	C4	D4	E4	F4	46205	28702
5	A5	B5	C5	D5	E5	F5	48040	28704
6								32095
7								46205
8
Hoja3

After Advanced Filter:

varios 20sep2024.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	A	B	C	D	E	F	ZIP CODE	ZIP CODE		A	B	C	D	E	F	ZIP CODE
2	A2	B2	C2	D2	E2	F2	38260	24281		A3	B3	C3	D3	E3	F3	32095
3	A3	B3	C3	D3	E3	F3	32095	28701		A4	B4	C4	D4	E4	F4	46205
4	A4	B4	C4	D4	E4	F4	46205	28702
5	A5	B5	C5	D5	E5	F5	48040	28704
6								32095
7								46205
8
Hoja3

thank you so much super helpful and marked as solution!