Lookup

[lstevenson]

Hi

I have no doubt there is any easy way around this, but it has driven me crazy and I can't seem to get it to work. I have attached a basic sheet on what i currently have. Sheet 1 is a record of policies and the commission amount we receive each month for that policy. Sheet 2 I will have a list of certain policies, I want to be able to create a formula that will look up the policy in sheet 1 and return the commission received for the current month. As you will see the first couple work with a lookup, but then it doesn't work. I will have lots of blank spaces as some commission is received monthly and some annually.

[fullysic]

Hi lstevenson,

I think the attached sheet should give you what you need. Let me know if it's what you were after.

fullysic