HOW DO I SELECT A RATE FROM A TABLE

  • Thread starter Thread starter mdwgno
  • Start date Start date
M

mdwgno

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
 
Back
Top