Lookup Help---Please

[larper]

Need some guidance, I have a table from FedEx showing Wgts on the left column and and Zone across the top, with the cost by Wgt and Zone below, like below

Zones
wgt 2 3 4 5 6 7 8
1 3.8 3.9 4.1 5.2 6.2 7.1 8.3
2 4.1 4.2 4.3 5.3 6.3 7.3 8.2
3

Not I want to build a table that will supply the wgt & zone, and I want to return the cost.

A B C
WGT ZONE $COST
2 4 $4.3

should I use a lookup or sumproduct. Thanks for any guidance!

 

[Domski]

Hi,

You can use Index and Match like this:

Book3
	A	B	C	D	E	F	G	H
1		2	3	4	5	6	7	8
2	1	3.8	3.9	4.1	5.2	6.2	7.1	8.3
3	2	4.1	4.2	4.3	5.3	6.3	7.3	8.2
4
5
6	Wgt	Zone	Cost
7	2	4	4.3
Sheet1

Hope it helps,

Dom