Using different spreadsheets to obtian values in cost equation

[Guest]

I am trying to calculate the cost of electricity for a given customer by
entering the zip code they live in and the amount of electricty used. This
requires using information from the Utilities website, a zip code baseline
Territory chart and a Territory Rate chart. I have no problem downloading
each chart and storing locally if this makes it easier.

Information is organized so that all zip codes are in row A and each
teritory code in corisponding row B

The Territory Rate Chart has the Territory Code in row A then row B has the
coresponding Baseline quanity for summer and row C has the value for winter.

What kind of if statement do I need to write so that when a zip code is
entered and a month by month electricty usage is given it returns baseline
values so that i can compute cost of electricty?

 

[Guest]

Assuming your Territory Rate chart is in Sheet 2, enter this formula which
assumes H1 contains Zip Code to return Summer Baseline:

=INDEX(Sheet2!B2:B50,MATCH(VLOOKUP(H1,A2:B100,2,0),Sheet2!A2:A50,0))

Winter Baseline:

=INDEX(Sheet2!C2:C50,MATCH(VLOOKUP(H1,A2:B100,2,0),Sheet2!A2:A50,0))

HTH

 

[Guest]

Assuming your Territory Rate chart is in Sheet 2, enter this formula which
assumes H1 contains Zip Code to return Summer Baseline:

=INDEX(Sheet2!B2:B50,MATCH(VLOOKUP(H1,A2:B100,2,0),Sheet2!A2:A50,0))

Winter Baseline:

=INDEX(Sheet2!C2:C50,MATCH(VLOOKUP(H1,A2:B100,2,0),Sheet2!A2:A50,0))

HTH