How are your rates set up? You should have a separate table, that
contains ranges of income and number of people.

Next, you can use named ranges to specify each year's figures. So, on
sheet 1996, you'll name a workbook-wide range called Rates1996, and
use a lookup function to find the range.

It's easier than it sounds, really. With formulas you'll probably get
consistently accurate results, so don't give up quite yet.


On Nov 20, 11:21 am, Leigh wrote:
Hello everyone....

I need some help. I have a column of dates and a column of income amounts. I
have multiple sheets in the workbook with income tables by year by
percentage. I need to create a formula to look in column F and pull data from
the sheet with the corresponding year. I also need the formula to look at the
income amount (Column G) and determine what percentage it is based on the
table. So if the date is sometime in 1999 and the income is within a certain
range, the cell would print 30%. If the date is in 1999 and the income is in
a higher range of amounts, it would print 50%. Or if the year is 2000 or 2004
or whatever. I only have 3 ranges of income to work with: 30%, 50% and 80%
but I have years 1996-2007.

This seems pretty complicated to me and if it's a huge hassle, please don't
lose any sleep over it. I can always come up with a plan B.

Thank you all for your help in advance.

Leigh