Preacher Man Posted March 11, 2008 Posted March 11, 2008 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.
Preacher Man Posted March 11, 2008 Author Posted March 11, 2008 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 Posted March 11, 2008 Author Posted March 11, 2008 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 Posted March 11, 2008 Posted March 11, 2008 You should have a look into the vlookup and hlookup functions, a quick search will give you loads of tutorials.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.