Vlookup, Match, Index Help

I have two tables and each table has a list of states. One table has a list of shipping costs to various parts of each state - multiple entries for each state. The other table has a list of charges for each state. I want to be able to quickly take the costs of shipping to say AZ in table 1, and subtract the cost associated with charge for AZ in table 2.

any help is appreciated.

Try this...

Entered in C3:

=[@[Shipping Charges]]-VLOOKUP([@State],Table2,2,0)

Data Range

	A	B	C	D
1
2	State	Shipping Charges	Delta	Column1
3	AZ	153	63	63
4	AZ	157	67	67
5	AZ	185	95	95
6	CA	121	21	21
7	CA	136	36	36
8	TX	145	20	20
9	TX	180	55	55
10

I entered this formula in D3:

=[@[Shipping Charges]]-VLOOKUP([@State],Table2,2,0)

It was automatically copied down to D9.