I have this workbook where I have various worksheets that have to work off a rate grid. This rate grid is a separate worksheet and has four companies which has the maximum number of e-mails allowed and the rate associated for that amount of e-mails (or any under). So it
Volume company1 company2 company3 company4
250,000 $0.0200 $0.0240 $0.0065 $0.0020
500,000 $0.0150 $0.0170 $0.0065 $0.0020
1,000,000 $0.0100 $0.0121 $0.0065 $0.0020
2,500,000 $0.0080 $0.0121 $0.0055 $0.0020
5,000,000 $0.0066 $0.0067 $0.0035 $0.0020
7,500,000 $0.0058 $0.0067 $0.0035 $0.0020
10,000,000 $0.0052 $0.0067 $0.0035 $0.0020
15,000,000 $0.0044 $0.0067 $0.0035 $0.0020
20,000,000 $0.0038 $0.0067 $0.0035 $0.0020
25,000,000 $0.0034 $0.0067 $0.0035 $0.0020
30,000,000 $0.0030 $0.0067 $0.0035 $0.0020
35,000,000 $0.0024 $0.0067 $0.0035 $0.0020
40,000,000 $0.0022 $0.0067 $0.0035 $0.0020
So I have 4 other worksheets for each company. I have a certain amount of e-mails in each column that we expect to send out. So I need to pull in the correct rate based on this. So let's say the following:
In my company1 worksheet I have that I will be sending out 236,000 e-mails; it should pull $0.0200. If I showed I was sending 500,000 then it would then switch to $0.0150 and so on. Is there an easy way to do this?
Thanks!
Bobby
Volume company1 company2 company3 company4
250,000 $0.0200 $0.0240 $0.0065 $0.0020
500,000 $0.0150 $0.0170 $0.0065 $0.0020
1,000,000 $0.0100 $0.0121 $0.0065 $0.0020
2,500,000 $0.0080 $0.0121 $0.0055 $0.0020
5,000,000 $0.0066 $0.0067 $0.0035 $0.0020
7,500,000 $0.0058 $0.0067 $0.0035 $0.0020
10,000,000 $0.0052 $0.0067 $0.0035 $0.0020
15,000,000 $0.0044 $0.0067 $0.0035 $0.0020
20,000,000 $0.0038 $0.0067 $0.0035 $0.0020
25,000,000 $0.0034 $0.0067 $0.0035 $0.0020
30,000,000 $0.0030 $0.0067 $0.0035 $0.0020
35,000,000 $0.0024 $0.0067 $0.0035 $0.0020
40,000,000 $0.0022 $0.0067 $0.0035 $0.0020
So I have 4 other worksheets for each company. I have a certain amount of e-mails in each column that we expect to send out. So I need to pull in the correct rate based on this. So let's say the following:
In my company1 worksheet I have that I will be sending out 236,000 e-mails; it should pull $0.0200. If I showed I was sending 500,000 then it would then switch to $0.0150 and so on. Is there an easy way to do this?
Thanks!
Bobby