Vlookup on multiple lines

[DYLANATT1999]

Hi,

My knowledge of excel is very basic so any help will be appreciated

I am trying to do a lookup to display all matching values in the cells H2 / I2 / J2 cells to the columns highlighted green in my spreadsheet. Is there any way of doing this?

Filter Sheet.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1								Steel Diameter	Steel Thickness	Steel Grade
2							Filter Criteria	76.1	2.5	235
3
4	ORDER NO.	LineQuantity	PromisedDeliveryDate	Drawing Number	BASE DIA	BASE THK	BASE GRADE	BASE LENGTH	Quantity	Meter Required	SHAFT DIAMETER	SHAFT THICKNESS	SHAFT GRADE	SHAFT LENGTH (mm)	Quantity3	Meter Required4
5	1	20	44319	B9043	139.7	3	355	2200	20	44	76.1	2.5	355	2085	20	41.7
6	2	50	44375	B0106 MDPT	139.7	3	275	2050	50	102.5	76.1	2.5	275	5150	50	257.5
7	3	66	44382	B10700	193.7	4	275	5100	66	336.6	139.7	3	275	10365	66	684.09
8	4	54	44382	B10757	168.3	3.6	275	4900	54	264.6	114.3	3	275	8365	54	451.71
9	5	1	44382	B10700	193.7	4	275	5100	1	5.1	139.7	3	275	10365	1	10.365
10	6	1	44382	B10757	168.3	3.6	275	4900	1	4.9	114.3	3	275	8365	1	8.365
11	7	1	44382	B10860	168.3	3.6	275	4600	1	4.6	88.9	3	275	6365	1	6.365
12	8	300	44389	B0106 MDPT	139.7	3	275	2050	300	615	76.1	2.5	275	5150	300	1545
13	9	4	44389	B6247	168.3	4	355	2750	4	11	114.3	3.6	355	11275	4	45.1
14	10	50	44389	B8708-500	168.3	5	275	2350	50	117.5	76.1	3.2	275	4765	50	238.25
15	11	20	44389	B8708-500	168.3	5	275	2350	20	47	76.1	3.2	275	4765	20	95.3
16	12	12	44396	B8951	168.3	5	355	2750	12	33	88.9	3	355	6680	12	80.16
17	13	20	44403	B5796	168.3	4.5	355	2850	20	57	114.3	3	355	8355	20	167.1
18	14	110	44403	ENTER	0	0	0	0	110	0	0	0	0	0	110	0
19	15	5	44403	B0104 LDPTFP	139.7	3	235	1000	5	5	76.1	2.5	235	3200	5	16
20	16	6	44410	B5842	168.3	5	355	2450	6	14.7	88.9	4	355	6545	6	39.27
21	17	20	44410	B5514	168.3	3.6	355	2750	20	55	114.3	3	355	6565	20	131.3
22	18	80	44410	B8971	139.7	4	355	2350	80	188	76.1	3	275	4765	80	381.2
23	19	2	44410	SC-140-76/4800	139.7	3	275	1800	2	3.6	76.1	2.5	275	0	2	0
24	20	15	44410	B7004	168.3	4.5	355	2650	15	39.75	114.3	3.6	355	8965	15	134.475
25	21	97	44410	B10701	193.7	5	275	1050	97	101.85	139.7	4	275	10565	97	1024.805
26	22	8	44417	B9854	168.3	5	275	1600	8	12.8	114.3	3	275	3095	8	24.76
27	23	1	44417	B2076	193.7	4	355	2950	1	2.95	139.7	3	355	10380	1	10.38
28	24	6	44417	B5649	168.3	3.6	275	2950	6	17.7	114.3	3	275	8665	6	51.99
29	25	1	44417	B0542	168.3	4.5	355	2750	1	2.75	114.3	3.2	355	8400	1	8.4
30	26	30	44417	B7001	139.7	3	355	1950	30	58.5	76.1	2.5	355	5265	30	157.95
31	27	5	44417	B5649	168.3	3.6	275	2950	5	14.75	114.3	3	275	8665	5	43.325
32	28	6	44417	B10951	193.7	6.3	355	1950	6	11.7	139.7	4.5	355	8450	6	50.7
33	29	50	44424	B0104 LDPT	139.7	3	235	1800	50	90	76.1	2.5	235	3200	50	160
34	30	50	44424	B5731	139.7	3	355	2200	50	110	76.1	2.5	355	2085	50	104.25
35	31	20	44424	B0106 MDPT	139.7	3	275	2050	20	41	76.1	2.5	275	5150	20	103
36	32	8	44424	B5731	139.7	3	355	2200	8	17.6	76.1	2.5	355	2085	8	16.68
37	33	24	44424	B0106 MDPT	139.7	3	275	2050	24	49.2	76.1	2.5	275	5150	24	123.6
38	34	18	44424	B5013	168.3	4.5	355	2950	18	53.1	114.3	3.6	355	8255	18	148.59
39	35	4	44424	B5013	168.3	4.5	355	2950	4	11.8	114.3	3.6	355	8255	4	33.02
40	36	192	44431	B10944	193.7	4	275	1900	192	364.8	76.1	3	275	4015	192	770.88
41	37	10	44431	B5741	139.7	3	355	2200	10	22	76.1	2.5	355	2120	10	21.2
42	38	2	44431	B10284	168.3	5	275	2750	2	5.5	114.3	3	275	6565	2	13.13
43	39	6	44431	B10256	193.7	4	275	3500	6	21	114.3	3.2	275	8115	6	48.69
44	40	2	44431	B0106 HDPT	139.7	5	355	2050	2	4.1	76.1	3	355	5150	2	10.3
45	41	1	44431	B9362	219.1	6.3	355	3700	1	3.7	168.3	4	355	9630	1	9.63
46	42	40	44431	B6871	168.3	3.6	355	2450	40	98	88.9	3	355	6545	40	261.8
47	43	1	44431	B5731	139.7	3	355	2200	1	2.2	76.1	2.5	355	2085	1	2.085
48	44	1	44431	B9165	219.1	5	355	3500	1	3.5	139.7	4	355	8015	1	8.015
49	45	27	44431	B1937 W	168.3	3.6	275	2750	27	74.25	114.3	3	275	6565	27	177.255
50	46	59	44431	B3625	219.1	5	355	3000	59	177	193.7	4	355	6470	59	381.73
51	47	4	44431	B9474	168.3	3.6	275	2050	4	8.2	114.3	3	275	7065	4	28.26
52	48	6	44431	B10592	139.7	3	275	2400	6	14.4	76.1	2.5	275	3000	6	18
53	49	3	44431	B7003	168.3	3.6	355	2350	3	7.05	88.9	3	355	7065	3	21.195
54	50	200	44431	B7978	139.7	5	355	2050	200	410	76.1	3	355	5065	200	1013
55	51	50	44431	B8951	168.3	5	355	2750	50	137.5	88.9	3	355	6680	50	334
56	52	25	44431	B8952	168.3	5	355	3500	25	87.5	114.3	4	355	8400	25	210
57	53	12	44431	B10957	193.7	5	355	3700	12	44.4	139.7	3	275	10400	12	124.8
58	54	4	44431	B7042	193.7	4	355	3000	4	12	139.7	3	355	8615	4	34.46
59	55	1	44431	B6247	168.3	4	355	2750	1	2.75	114.3	3.6	355	11275	1	11.275
60	56	1	44431	B6247	168.3	4	355	2750	1	2.75	114.3	3.6	355	11275	1	11.275
61	57	4	44431	B7547	139.7	5	275	1950	4	7.8	76.1	3	275	5165	4	20.66
62	58	11	44431	B0106 MDPT	139.7	3	275	2050	11	22.55	76.1	2.5	275	5150	11	56.65
63	59	10	44431	B0106 MDPT	139.7	3	275	2050	10	20.5	76.1	2.5	275	5150	10	51.5
64	60	30	44431	B0106 MDPT	139.7	3	275	2050	30	61.5	76.1	2.5	275	5150	30	154.5
65	61	40	44438	B0106 MDPT	139.7	3	275	2050	40	82	76.1	2.5	275	5150	40	206
66	62	40	44438	B0106 MDPT	139.7	3	275	2050	40	82	76.1	2.5	275	5150	40	206
67	63	2	44438	B0106 MDPT	139.7	3	275	2050	2	4.1	76.1	2.5	275	5150	2	10.3
68	64	400	44438	B0106 MDPT	139.7	3	275	2050	400	820	76.1	2.5	275	5150	400	2060
69	65	140	44438	B0106 MDPT	139.7	3	275	2050	140	287	76.1	2.5	275	5150	140	721
70	66	35	44438	B5731	139.7	3	355	2200	35	77	76.1	2.5	355	2085	35	72.975
71	67	15	44438	B6868	168.3	3.6	275	2750	15	41.25	88.9	3	355	6565	15	98.475
72	68	15	44438	B5649	168.3	3.6	275	2950	15	44.25	114.3	3	275	8665	15	129.975
73	69	5	44438	B9994	168.3	5	275	2950	5	14.75	114.3	4	275	8665	5	43.325
74	70	10	44438	B8816	168.3	4	355	2450	10	24.5	114.3	3.6	355	3405	10	34.05
75	71	9	44438	B10911	193.7	6	275	3050	9	27.45	139.7	3.6	275	10765	9	96.885
76	72	18	44438	B10910	168.3	3.6	355	2850	18	51.3	139.7	3	355	8765	18	157.77
77	73	150	44438	B0224 SE	168.3	3.6	355	2750	150	412.5	114.3	3	355	6300	150	945
78	74	4	44438	B9205	168.3	4	355	2250	4	9	114.3	3.2	355	6745	4	26.98
79	75	200	44438	B6859 W	168.3	3.6	275	2300	200	460	88.9	3	275	5000	200	1000
80	76	48	44438	B1437	168.3	3.6	235	2300	48	110.4	88.9	3	275	4515	48	216.72
81	77	2	44438	B5731	139.7	3	355	2200	2	4.4	76.1	2.5	355	2085	2	4.17
82	78	97	44438	B10701	193.7	5	275	1050	97	101.85	139.7	4	275	10565	97	1024.805
83	79	1	44438	B10701	193.7	5	275	1050	1	1.05	139.7	4	275	10565	1	10.565
84	80	9	44438	B7547	139.7	5	275	1950	9	17.55	76.1	3	275	5165	9	46.485
85	81	17	44438	B0106 MDPT	139.7	3	275	2050	17	34.85	76.1	2.5	275	5150	17	87.55
86	82	8	44438	B7978	139.7	5	355	2050	8	16.4	76.1	3	355	5065	8	40.52
87	83	23	44438	B0106 MDPT	139.7	3	275	2050	23	47.15	76.1	2.5	275	5150	23	118.45
88	84	13	44438	B0106 MDPT	139.7	3	275	2050	13	26.65	76.1	2.5	275	5150	13	66.95
89	85	7	44445	B5649	168.3	3.6	275	2950	7	20.65	114.3	3	275	8665	7	60.655
90	86	7	44445	B5741	139.7	3	355	2200	7	15.4	76.1	2.5	355	2120	7	14.84
91	87	50	44445	B0106 MDPT	139.7	3	275	2050	50	102.5	76.1	2.5	275	5150	50	257.5
92	88	50	44445	B9146	139.7	3.2	355	2100	50	105	76.1	2.5	355	5015	50	250.75
93	89	9	44445	B5731	139.7	3	355	2200	9	19.8	76.1	2.5	355	2085	9	18.765
94	90	198	44445	B10944	193.7	4	275	1900	198	376.2	76.1	3	275	4015	198	794.97
95	91	20	44445	B0105 MDPT	139.7	3	275	1800	20	36	76.1	2.5	275	4200	20	84
96	92	140	44445	B0106 MDPT	139.7	3	275	2050	140	287	76.1	2.5	275	5150	140	721
97	93	48	44445	B7367	168.3	3.6	355	2950	48	141.6	114.3	3	275	8665	48	415.92
98	94	11	44445	B7980	168.3	5	355	2350	11	25.85	114.3	3	355	6965	11	76.615
99	95	2	44445	ENTER	0	0	0	0	2	0	0	0	0	0	2	0
100	96	3	44445	B0105 LDPT	139.7	3	235	1800	3	5.4	76.1	2.5	235	4200	3	12.6
101	97	10	44445	ENTER	0	0	0	0	10	0	0	0	0	0	10	0
102	98	12	44445	B0542	168.3	4.5	355	2750	12	33	114.3	3.2	355	8400	12	100.8
103	99	150	44445	B0224 SE	168.3	3.6	355	2750	150	412.5	114.3	3	355	6300	150	945
104	100	2	44445	B10976	139.7	4	355	1850	2	3.7	88.9	3	355	2655	2	5.31
105	101	2	44445	B10978	168.3	5	355	2250	2	4.5	114.3	3.6	355	5665	2	11.33
106	102	2	44445	B6295 SE	219.1	5	355	3500	2	7	168.3	4	355	7603	2	15.206
107	103	2	44445	B8691	219.1	5	355	3200	2	6.4	168.3	4.5	355	10415	2	20.83
108	104	4	44445	B5731	139.7	3	355	2200	4	8.8	76.1	2.5	355	2085	4	8.34
109	105	30	44445	B0104 LDPT	139.7	3	235	1800	30	54	76.1	2.5	235	3200	30	96
110	106	8	44445	B0106 MDPT	139.7	3	275	2050	8	16.4	76.1	2.5	275	5150	8	41.2
111	107	1	44445	SC-140-114/5000	139.7	3	275	1800	1	1.8	114.3	3	275	3315	1	3.315
112	108	1	44445	HDSC-140-114/5000	139.7	5	275	1800	1	1.8	114.3	5	275	3315	1	3.315
113	109	30	44445	B0106 MDPT	139.7	3	275	2050	30	61.5	76.1	2.5	275	5150	30	154.5
114	110	10	44445	B0106 MDPT	139.7	3	275	2050	10	20.5	76.1	2.5	275	5150	10	51.5
115	111	200	44445	B10011	139.7	5	355	2350	200	470	76.1	3	355	4950	200	990
116	112	28	44452	B0106 HDPT	139.7	5	355	2050	28	57.4	76.1	3	355	5150	28	144.2
117	113	2	44452	B6247	168.3	4	355	2750	2	5.5	114.3	3.6	355	11275	2	22.55
118	114	40	44452	B0106 MDPT	139.7	3	275	2050	40	82	76.1	2.5	275	5150	40	206
119	115	7	44452	B7004	168.3	4.5	355	2650	7	18.55	114.3	3.6	355	8965	7	62.755
120	116	30	44452	B7197	168.3	3.6	355	2950	30	88.5	114.3	3	275	8665	30	259.95
121	117	10	44452	B6868	168.3	3.6	275	2750	10	27.5	88.9	3	355	6565	10	65.65
122	118	20	44452	B0106 MDPT	139.7	3	275	2050	20	41	76.1	2.5	275	5150	20	103
Sheet3

Cells with Data Validation
Cell	Allow	Criteria
J2	List	=Sheet2!$B$2:$B$4
H2	List	=Sheet2!$A$2:$A$14

 

[hrayani]

Hi,
If I have not misunderstood the question... you can use conditional formatting

Is this what you want ???

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1								Steel Diameter	Steel Thickness	Steel Grade
2							Filter Criteria	76.1	2.5	235
3
4	ORDER NO.	LineQuantity	PromisedDeliveryDate	Drawing Number	BASE DIA	BASE THK	BASE GRADE	BASE LENGTH	Quantity	Meter Required	SHAFT DIAMETER	SHAFT THICKNESS	SHAFT GRADE	SHAFT LENGTH (mm)	Quantity3	Meter Required4
5	1	20	44319	B9043	139.7	3	355	2200	20	44	76.1	2.5	355	2085	20	41.7
6	2	50	44375	B0106 MDPT	139.7	3	275	2050	50	102.5	76.1	2.5	275	5150	50	257.5
7	3	66	44382	B10700	193.7	4	275	5100	66	336.6	139.7	3	275	10365	66	684.09
8	4	54	44382	B10757	168.3	3.6	275	4900	54	264.6	114.3	3	275	8365	54	451.71
9	5	1	44382	B10700	193.7	4	275	5100	1	5.1	139.7	3	275	10365	1	10.365
10	6	1	44382	B10757	168.3	3.6	275	4900	1	4.9	114.3	3	275	8365	1	8.365
11	7	1	44382	B10860	168.3	3.6	275	4600	1	4.6	88.9	3	275	6365	1	6.365
12	8	300	44389	B0106 MDPT	139.7	3	275	2050	300	615	76.1	2.5	275	5150	300	1545
13	9	4	44389	B6247	168.3	4	355	2750	4	11	114.3	3.6	355	11275	4	45.1
14	10	50	44389	B8708-500	168.3	5	275	2350	50	117.5	76.1	3.2	275	4765	50	238.25
15	11	20	44389	B8708-500	168.3	5	275	2350	20	47	76.1	3.2	275	4765	20	95.3
16	12	12	44396	B8951	168.3	5	355	2750	12	33	88.9	3	355	6680	12	80.16
17	13	20	44403	B5796	168.3	4.5	355	2850	20	57	114.3	3	355	8355	20	167.1
18	14	110	44403	ENTER	0	0	0	0	110	0	0	0	0	0	110	0
19	15	5	44403	B0104 LDPTFP	139.7	3	235	1000	5	5	76.1	2.5	235	3200	5	16
20	16	6	44410	B5842	168.3	5	355	2450	6	14.7	88.9	4	355	6545	6	39.27
21	17	20	44410	B5514	168.3	3.6	355	2750	20	55	114.3	3	355	6565	20	131.3
22	18	80	44410	B8971	139.7	4	355	2350	80	188	76.1	3	275	4765	80	381.2
23	19	2	44410	SC-140-76/4800	139.7	3	275	1800	2	3.6	76.1	2.5	275	0	2	0
24	20	15	44410	B7004	168.3	4.5	355	2650	15	39.75	114.3	3.6	355	8965	15	134.475
25	21	97	44410	B10701	193.7	5	275	1050	97	101.85	139.7	4	275	10565	97	1024.805
26	22	8	44417	B9854	168.3	5	275	1600	8	12.8	114.3	3	275	3095	8	24.76
27	23	1	44417	B2076	193.7	4	355	2950	1	2.95	139.7	3	355	10380	1	10.38
28	24	6	44417	B5649	168.3	3.6	275	2950	6	17.7	114.3	3	275	8665	6	51.99
29	25	1	44417	B0542	168.3	4.5	355	2750	1	2.75	114.3	3.2	355	8400	1	8.4
30	26	30	44417	B7001	139.7	3	355	1950	30	58.5	76.1	2.5	355	5265	30	157.95
31	27	5	44417	B5649	168.3	3.6	275	2950	5	14.75	114.3	3	275	8665	5	43.325
32	28	6	44417	B10951	193.7	6.3	355	1950	6	11.7	139.7	4.5	355	8450	6	50.7
33	29	50	44424	B0104 LDPT	139.7	3	235	1800	50	90	76.1	2.5	235	3200	50	160
34	30	50	44424	B5731	139.7	3	355	2200	50	110	76.1	2.5	355	2085	50	104.25
35	31	20	44424	B0106 MDPT	139.7	3	275	2050	20	41	76.1	2.5	275	5150	20	103
36	32	8	44424	B5731	139.7	3	355	2200	8	17.6	76.1	2.5	355	2085	8	16.68
37	33	24	44424	B0106 MDPT	139.7	3	275	2050	24	49.2	76.1	2.5	275	5150	24	123.6
38	34	18	44424	B5013	168.3	4.5	355	2950	18	53.1	114.3	3.6	355	8255	18	148.59
39	35	4	44424	B5013	168.3	4.5	355	2950	4	11.8	114.3	3.6	355	8255	4	33.02
40	36	192	44431	B10944	193.7	4	275	1900	192	364.8	76.1	3	275	4015	192	770.88
41	37	10	44431	B5741	139.7	3	355	2200	10	22	76.1	2.5	355	2120	10	21.2
42	38	2	44431	B10284	168.3	5	275	2750	2	5.5	114.3	3	275	6565	2	13.13
43	39	6	44431	B10256	193.7	4	275	3500	6	21	114.3	3.2	275	8115	6	48.69
44	40	2	44431	B0106 HDPT	139.7	5	355	2050	2	4.1	76.1	3	355	5150	2	10.3
45	41	1	44431	B9362	219.1	6.3	355	3700	1	3.7	168.3	4	355	9630	1	9.63
46	42	40	44431	B6871	168.3	3.6	355	2450	40	98	88.9	3	355	6545	40	261.8
47	43	1	44431	B5731	139.7	3	355	2200	1	2.2	76.1	2.5	355	2085	1	2.085
48	44	1	44431	B9165	219.1	5	355	3500	1	3.5	139.7	4	355	8015	1	8.015
49	45	27	44431	B1937 W	168.3	3.6	275	2750	27	74.25	114.3	3	275	6565	27	177.255
50	46	59	44431	B3625	219.1	5	355	3000	59	177	193.7	4	355	6470	59	381.73
51	47	4	44431	B9474	168.3	3.6	275	2050	4	8.2	114.3	3	275	7065	4	28.26
52	48	6	44431	B10592	139.7	3	275	2400	6	14.4	76.1	2.5	275	3000	6	18
53	49	3	44431	B7003	168.3	3.6	355	2350	3	7.05	88.9	3	355	7065	3	21.195
54	50	200	44431	B7978	139.7	5	355	2050	200	410	76.1	3	355	5065	200	1013
55	51	50	44431	B8951	168.3	5	355	2750	50	137.5	88.9	3	355	6680	50	334
56	52	25	44431	B8952	168.3	5	355	3500	25	87.5	114.3	4	355	8400	25	210
57	53	12	44431	B10957	193.7	5	355	3700	12	44.4	139.7	3	275	10400	12	124.8
58	54	4	44431	B7042	193.7	4	355	3000	4	12	139.7	3	355	8615	4	34.46
59	55	1	44431	B6247	168.3	4	355	2750	1	2.75	114.3	3.6	355	11275	1	11.275
60	56	1	44431	B6247	168.3	4	355	2750	1	2.75	114.3	3.6	355	11275	1	11.275
61	57	4	44431	B7547	139.7	5	275	1950	4	7.8	76.1	3	275	5165	4	20.66
62	58	11	44431	B0106 MDPT	139.7	3	275	2050	11	22.55	76.1	2.5	275	5150	11	56.65
63	59	10	44431	B0106 MDPT	139.7	3	275	2050	10	20.5	76.1	2.5	275	5150	10	51.5
64	60	30	44431	B0106 MDPT	139.7	3	275	2050	30	61.5	76.1	2.5	275	5150	30	154.5
65	61	40	44438	B0106 MDPT	139.7	3	275	2050	40	82	76.1	2.5	275	5150	40	206
66	62	40	44438	B0106 MDPT	139.7	3	275	2050	40	82	76.1	2.5	275	5150	40	206
67	63	2	44438	B0106 MDPT	139.7	3	275	2050	2	4.1	76.1	2.5	275	5150	2	10.3
68	64	400	44438	B0106 MDPT	139.7	3	275	2050	400	820	76.1	2.5	275	5150	400	2060
69	65	140	44438	B0106 MDPT	139.7	3	275	2050	140	287	76.1	2.5	275	5150	140	721
70	66	35	44438	B5731	139.7	3	355	2200	35	77	76.1	2.5	355	2085	35	72.975
71	67	15	44438	B6868	168.3	3.6	275	2750	15	41.25	88.9	3	355	6565	15	98.475
72	68	15	44438	B5649	168.3	3.6	275	2950	15	44.25	114.3	3	275	8665	15	129.975
73	69	5	44438	B9994	168.3	5	275	2950	5	14.75	114.3	4	275	8665	5	43.325
74	70	10	44438	B8816	168.3	4	355	2450	10	24.5	114.3	3.6	355	3405	10	34.05
75	71	9	44438	B10911	193.7	6	275	3050	9	27.45	139.7	3.6	275	10765	9	96.885
76	72	18	44438	B10910	168.3	3.6	355	2850	18	51.3	139.7	3	355	8765	18	157.77
77	73	150	44438	B0224 SE	168.3	3.6	355	2750	150	412.5	114.3	3	355	6300	150	945
78	74	4	44438	B9205	168.3	4	355	2250	4	9	114.3	3.2	355	6745	4	26.98
79	75	200	44438	B6859 W	168.3	3.6	275	2300	200	460	88.9	3	275	5000	200	1000
80	76	48	44438	B1437	168.3	3.6	235	2300	48	110.4	88.9	3	275	4515	48	216.72
81	77	2	44438	B5731	139.7	3	355	2200	2	4.4	76.1	2.5	355	2085	2	4.17
82	78	97	44438	B10701	193.7	5	275	1050	97	101.85	139.7	4	275	10565	97	1024.805
83	79	1	44438	B10701	193.7	5	275	1050	1	1.05	139.7	4	275	10565	1	10.565
84	80	9	44438	B7547	139.7	5	275	1950	9	17.55	76.1	3	275	5165	9	46.485
85	81	17	44438	B0106 MDPT	139.7	3	275	2050	17	34.85	76.1	2.5	275	5150	17	87.55
86	82	8	44438	B7978	139.7	5	355	2050	8	16.4	76.1	3	355	5065	8	40.52
87	83	23	44438	B0106 MDPT	139.7	3	275	2050	23	47.15	76.1	2.5	275	5150	23	118.45
88	84	13	44438	B0106 MDPT	139.7	3	275	2050	13	26.65	76.1	2.5	275	5150	13	66.95
89	85	7	44445	B5649	168.3	3.6	275	2950	7	20.65	114.3	3	275	8665	7	60.655
90	86	7	44445	B5741	139.7	3	355	2200	7	15.4	76.1	2.5	355	2120	7	14.84
91	87	50	44445	B0106 MDPT	139.7	3	275	2050	50	102.5	76.1	2.5	275	5150	50	257.5
92	88	50	44445	B9146	139.7	3.2	355	2100	50	105	76.1	2.5	355	5015	50	250.75
93	89	9	44445	B5731	139.7	3	355	2200	9	19.8	76.1	2.5	355	2085	9	18.765
94	90	198	44445	B10944	193.7	4	275	1900	198	376.2	76.1	3	275	4015	198	794.97
95	91	20	44445	B0105 MDPT	139.7	3	275	1800	20	36	76.1	2.5	275	4200	20	84
96	92	140	44445	B0106 MDPT	139.7	3	275	2050	140	287	76.1	2.5	275	5150	140	721
97	93	48	44445	B7367	168.3	3.6	355	2950	48	141.6	114.3	3	275	8665	48	415.92
98	94	11	44445	B7980	168.3	5	355	2350	11	25.85	114.3	3	355	6965	11	76.615
99	95	2	44445	ENTER	0	0	0	0	2	0	0	0	0	0	2	0
100	96	3	44445	B0105 LDPT	139.7	3	235	1800	3	5.4	76.1	2.5	235	4200	3	12.6
101	97	10	44445	ENTER	0	0	0	0	10	0	0	0	0	0	10	0
102	98	12	44445	B0542	168.3	4.5	355	2750	12	33	114.3	3.2	355	8400	12	100.8
103	99	150	44445	B0224 SE	168.3	3.6	355	2750	150	412.5	114.3	3	355	6300	150	945
104	100	2	44445	B10976	139.7	4	355	1850	2	3.7	88.9	3	355	2655	2	5.31
105	101	2	44445	B10978	168.3	5	355	2250	2	4.5	114.3	3.6	355	5665	2	11.33
106	102	2	44445	B6295 SE	219.1	5	355	3500	2	7	168.3	4	355	7603	2	15.206
107	103	2	44445	B8691	219.1	5	355	3200	2	6.4	168.3	4.5	355	10415	2	20.83
108	104	4	44445	B5731	139.7	3	355	2200	4	8.8	76.1	2.5	355	2085	4	8.34
109	105	30	44445	B0104 LDPT	139.7	3	235	1800	30	54	76.1	2.5	235	3200	30	96
110	106	8	44445	B0106 MDPT	139.7	3	275	2050	8	16.4	76.1	2.5	275	5150	8	41.2
111	107	1	44445	SC-140-114/5000	139.7	3	275	1800	1	1.8	114.3	3	275	3315	1	3.315
112	108	1	44445	HDSC-140-114/5000	139.7	5	275	1800	1	1.8	114.3	5	275	3315	1	3.315
113	109	30	44445	B0106 MDPT	139.7	3	275	2050	30	61.5	76.1	2.5	275	5150	30	154.5
114	110	10	44445	B0106 MDPT	139.7	3	275	2050	10	20.5	76.1	2.5	275	5150	10	51.5
115	111	200	44445	B10011	139.7	5	355	2350	200	470	76.1	3	355	4950	200	990
116	112	28	44452	B0106 HDPT	139.7	5	355	2050	28	57.4	76.1	3	355	5150	28	144.2
117	113	2	44452	B6247	168.3	4	355	2750	2	5.5	114.3	3.6	355	11275	2	22.55
118	114	40	44452	B0106 MDPT	139.7	3	275	2050	40	82	76.1	2.5	275	5150	40	206
119	115	7	44452	B7004	168.3	4.5	355	2650	7	18.55	114.3	3.6	355	8965	7	62.755
120	116	30	44452	B7197	168.3	3.6	355	2950	30	88.5	114.3	3	275	8665	30	259.95
121	117	10	44452	B6868	168.3	3.6	275	2750	10	27.5	88.9	3	355	6565	10	65.65
122	118	20	44452	B0106 MDPT	139.7	3	275	2050	20	41	76.1	2.5	275	5150	20	103
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G5:G122,M5:M122	Cell Value	=$J$2	text	NO
F5:F122,L5:L122	Cell Value	=$I$2	text	NO
E5:E122,K5:K122	Cell Value	=$H$2	text	NO

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Vlookup on multiple lines
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[DYLANATT1999]

Thankyou for the reply, I wish it was that easy lol.

I have done a simplified version which I hope answers the query

Filter Sheet - Copy.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1										Parameters
2										Diameter	Thickness	GRADE
3		BASE SECTION			SHAFT SECTION				Filter Criteria
4	ORDER NO.	BASE DIAMETER	BASE THICKNESS	BASE GRADE	SHAFT DIAMETER	SHAFT THICKNESS	SHAFT GRADE
5	1	139.7	3	355	76.1	2.5	355		No filter all rows apparent
6	2	139.7	3	275	76.1	2.5	275
7	3	193.7	4	275	139.7	3	275
8	4	168.3	3.6	275	114.3	3	275
9	5	193.7	4	275	139.7	3	275
10	6	168.3	3.6	275	114.3	3	275
11	7	168.3	3.6	275	88.9	3	275
12	8	139.7	3	275	76.1	2.5	275
13	9	168.3	4	355	114.3	3.6	355
14	10	168.3	5	275	76.1	3.2	275
15	11	168.3	5	275	76.1	3.2	275
16	12	168.3	5	355	88.9	3	355
17	13	168.3	4.5	355	114.3	3	355
18	14	0	0	0	0	0	0
19	15	139.7	3	235	76.1	2.5	235
20	16	168.3	5	355	88.9	4	355
21
22
23
24
25
26										Parameters
27										Diameter	Thickness	GRADE
28		BASE SECTION			SHAFT SECTION				Filter Criteria	139.7	3	275
29	ORDER NO.	BASE DIAMETER	BASE THICKNESS	BASE GRADE	SHAFT DIAMETER	SHAFT THICKNESS	SHAFT GRADE
31	2	139.7	3	275	76.1	2.5	275
37	8	139.7	3	275	76.1	2.5	275		Criteria applied to both BASE SECTION and SHAFT SECTION
46	ORDER NO.	BASE DIAMETER	BASE THICKNESS	BASE GRADE	SHAFT DIAMETER	SHAFT THICKNESS	SHAFT GRADE		Based on criteria set, order no. 2 / 8 / 3 / 5 Contain the steel 139.7 & 3.0 & S275
49	3	193.7	4	275	139.7	3	275
51	5	193.7	4	275	139.7	3	275
Sheet3

Cells with Data Validation
Cell	Allow	Criteria
J3	List	=Sheet2!$A$2:$A$14
J28	List	=Sheet2!$A$2:$A$14
L3	List	=Sheet2!$B$2:$B$4
L28	List	=Sheet2!$B$2:$B$4

As seen in the first section a reduced set of data

In the second section, you can see where I have specified what I want to find and then the set of orders that contain this data