I am getting a major headache trying to think of a formula to make desired calculations and may come to the conclusion that one does not exist. Basically I want a formula that will calculate the split in investments required to provide an equal income for 2 people. The income will also be dependent on an income rate, which in turn is dependent on the age of each person. Not sure how else to explain it but I've attached a spreadsheet to help in this. Sheet 1 titled 'Income Rates' shows the income rate applicable to specific ages. Sheet 2 entitled 'Investment Splits' is where I am coming up with my problem. I've created a vlookup formula in column G so that the appropriate income rate is derived from the previous sheet based on a specific age. Now I'd like a formula that can calculate a split percentage in cells H3 & H5 in order to create an equal income for a couple in cells I3 & I5, based on the total value of investment and the appropriate income rate.

Am I searching for a formula that doesn't exist??