D
DK1314
We have several maintenance packages that we sell and we need to know
what we will be paid on a recurring basis.
I've created a Validation table to give me a drop down and beside it I
have placed a number of values relating to the different terms and
packages available. For example, if a customer takes a standard care
package on a three year term, I know the company will only realise
revenue for the 2nd and 3rd year so I want to enter a value for the
whole term and use LOOKUP to determine the package selected and then
the relative calculation.(3 year standard care contract value
multiplied by.6666667 will give me our achieveable revenue).
I have listed the options and the multiplying factors side by side on a
separate sheet and have named the ranges above. But when I try and
layout the VLOOKUP formula it gives me a name error.
Can anyone help?
what we will be paid on a recurring basis.
I've created a Validation table to give me a drop down and beside it I
have placed a number of values relating to the different terms and
packages available. For example, if a customer takes a standard care
package on a three year term, I know the company will only realise
revenue for the 2nd and 3rd year so I want to enter a value for the
whole term and use LOOKUP to determine the package selected and then
the relative calculation.(3 year standard care contract value
multiplied by.6666667 will give me our achieveable revenue).
I have listed the options and the multiplying factors side by side on a
separate sheet and have named the ranges above. But when I try and
layout the VLOOKUP formula it gives me a name error.
Can anyone help?