Help with excel spreadsheets.

[Preacher Man]

hi,

 

i have a spread sheet which i use to calculate different costs and figure out how much i can charge for something.

 

part of the calculation involves me using two charges that are an average value from charges that go up yearly.

so i have a seperate sheet that contains the charge and the financial year i.e.

 

year - charge A - charge B

01/04/05 - 1.005 - 0.998

01/04/06 - 1.015 - 1.004

hyphens are to show its the next cell.

 

is there a way of putting the date im billing from and to, and it brings the relevant charges through from the other sheet for the corresponding year?

 

i can email the spreadsheet if it will make it easier.

 

thanks, a confused preacher.

[Tricky]

What are the 2 numbers on each row?

[Preacher Man]

they are figures i use to multiply another number by.

 

so if they use 100 units they are charged

 

 

100 x charge A

 

100 x charge B

[Preacher Man]

I have to put the dates im charging them from and to anyway so im after those fields looking up the relevant charge on the other sheet.

[MattTurner]

You should have a look into the vlookup and hlookup functions, a quick search will give you loads of tutorials.