Index Match Match returning incorrect value from table

Hi all,

I have the following table of data, and I'm trying to extract the amount payable in column A, depending upon both a persons salary and the start and finish date from the range in column D & E. So for example if a persons salary was $75k on 1/8/12 the amount payable would be $80.00 (if that makes sense)

My array formula is

Please Login or Register  to view this content.

HTML Code: 

However the result in all instances is $190 which is incorrect, any idea where I'm going wrong in the formula?

Many thanks

David

Can you post a sample book?
Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Thanks Debraj Roy, the solution worked perfectly.