Actually......it also depends on the number of people, not just the amount
and the year. *sigh* I may just have to do it manually.....

"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