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?
Bookmarks