Jeff,

I suspect that whoever has given you the new numbers for the table
(your boss?) has made a simple mistake in one of them that has
propagated through.

When you first posed this question in December, my instinct was to use
a lookup table, but then I spotted a simple relationship between the
numbers in the table which made the table redundant. If you definitely
have to stick with these new numbers, then I would suggest a table this
time. Assume you have the following table occupying cells N1 to P8
(I've had to guess the second set of values - correct as necessary).

1 1037 1476
2 1390 1979
3 1744 2483
4 2097 2986
5 2450 3489
6 2803 3992
7 3156 4495
8 3509 4998

The following formula will give you "Free", "Reduced" or "Paid" to suit
your criteria:

=IF(L4<VLOOKUP((A10+1),N1:O8,2,0),"Free",
IF(L4<VLOOKUP((A10+1),N1:P8,3,0),"Reduced","Paid") )

This is all one formula, and assumes L4 is current income and A10 is
the number in the household, as in your earlier posting. This will only
cope with up to 7 in the household - if you have more then you will
need to extend the table down and adjust the references to O8 and P8 in
the formula.

Hope this helps this time - you can always apply it to the previous
situation.

Pete