how do i select a status from a table or array based on # in household and
income "less than" such as the following:

# in household Free Reduced
1 13520 19240
2 18200 25900
3 22880 32560
4 27560 39220

There is no column mentioning the 'income' slabs...If you mean to get the
figures based on the # in household you can use the below formula..If not
post back with an example of what you are looking for....

=LOOKUP(numberinhousehold,A2:A5,B2:B5)



If this post helps click Yes
---------------
Jacob Skaria


"mdwgno" wrote:

how do i select a status from a table or array based on # in household and
income "less than" such as the following:

# in household Free Reduced
1 13520 19240
2 18200 25900
3 22880 32560
4 27560 39220