Using different spreadsheets to obtian values in cost equation
 

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?

Using different spreadsheets to obtian values in cost equation
 

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

"Eric" wrote:

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?