Vlookup formula

[Utradeshow]

Hi All,

Trying to have a formula do the following

When input cells A5 & B5 match data in columns A&B based on the weight C5 it will return the correct number in Columns N-R

Example

ABE to BDL 1500 21.23

Excel 2012
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	Origin	Dest	Weight		Weight									100	1000	3000	5000	7500
4
5	ABE	BDL	1500		21.23
6
7	ABE	ABQ	2200	900	4	Fr	Mo	Mo	Mo	Tu				41.43	37.8	35.96	34.14	32.34
8	ABE	ALB	1900	900	1	Tu	We	Th	Fr	Mo				25.56	24.1	23.14	21.92	20.7
9	ABE	ATL	2200	800	2	We	Th	Fr	Mo	Mo				25.32	23.88	22.92	21.72	20.52
10	ABE	AUS	2200	1000	3	Th	Fr	Mo	Mo	Mo				38.6	31.58	30.65	30.19	29.26
11	ABE	BDL	1900	900	1	Tu	We	Th	Fr	Mo				22.51	21.23	20.38	19.35	18.28
12	ABE	BHM	1900	1030	2	We	Th	Fr	Mo	Mo				36.75	33.52	31.92	30.29	28.7
13	ABE	BNA	2200	800	2	We	Th	Fr	Mo	Mo				37.25	35.11	33.67	31.87	30.07
14	ABE	BOS	1900	1000	1	Tu	We	Th	Fr	Mo				22.73	21.44	20.6	19.49	18.45
15	ABE	BRL	2200	1200	3	Th	Fr	Mo	Mo	Mo				35.25	33.14	31.79	30.08	28.39
16	ABE	BTR	1900	1300	2	We	Th	Fr	Mo	Mo				36.13	34.02	32.62	30.89	29.15
Linehaul

 

[njimack]

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	Origin	Dest	Weight									Weight		100	1000	3000	5000	7500	Min
2
3
4
5	ABE	BDL	1500									21.23
6
7	ABE	ABQ	2200	900	4	Fr	Mo	Mo	Mo	Tu				41.43	37.8	35.96	34.14	32.34	41.81
8	ABE	ALB	1900	900	1	Tu	We	Th	Fr	Mo				25.56	24.1	23.14	21.92	20.7	34.83
9	ABE	ATL	2200	800	2	We	Th	Fr	Mo	Mo				25.32	23.88	22.92	21.72	20.52	41.81
10	ABE	AUS	2200	1000	3	Th	Fr	Mo	Mo	Mo				38.6	31.58	30.65	30.19	29.26	41.81
11	ABE	BDL	1900	900	1	Tu	We	Th	Fr	Mo				22.51	21.23	20.38	19.35	18.28	34.83
12	ABE	BHM	1900	1030	2	We	Th	Fr	Mo	Mo				36.75	33.52	31.92	30.29	28.7	41.81
13	ABE	BNA	2200	800	2	We	Th	Fr	Mo	Mo				37.25	35.11	33.67	31.87	30.07	41.81
Sheet2

 

[Utradeshow]

That is awesome, Is it possible to have the input cells on Sheet 1 and have the data on sheet 2?

 

[Utradeshow]

If you could add another condition, This one the weight is not a condition. If A5 & B5 MATCH it would return the MIN in column S

Excel 2012
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	Origin	Dest	Weight		Weight		Min							100	1000	3000	5000	7500	Min
4
5	abe	bdl	1306		21.23		34.83
6
7	ABE	ABQ	2200	900	4	Fr	Mo	Mo	Mo	Tu				41.43	37.8	35.96	34.14	32.34	41.81
8	ABE	ALB	1900	900	1	Tu	We	Th	Fr	Mo				25.56	24.1	23.14	21.92	20.7	34.83
9	ABE	ATL	2200	800	2	We	Th	Fr	Mo	Mo				25.32	23.88	22.92	21.72	20.52	41.81
10	ABE	AUS	2200	1000	3	Th	Fr	Mo	Mo	Mo				38.6	31.58	30.65	30.19	29.26	41.81
11	ABE	BDL	1900	900	1	Tu	We	Th	Fr	Mo				22.51	21.23	20.38	19.35	18.28	34.83
12	ABE	BHM	1900	1030	2	We	Th	Fr	Mo	Mo				36.75	33.52	31.92	30.29	28.7	41.81
13	ABE	BNA	2200	800	2	We	Th	Fr	Mo	Mo				37.25	35.11	33.67	31.87	30.07	41.81
14	ABE	BOS	1900	1000	1	Tu	We	Th	Fr	Mo				22.73	21.44	20.6	19.49	18.45	34.83
15	ABE	BRL	2200	1200	3	Th	Fr	Mo	Mo	Mo				35.25	33.14	31.79	30.08	28.39	41.81
Linehaul