HOW DO I SELECT A RATE FROM A TABLE

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
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AppleScript - How do I select a text ? 1
Search for one answer on multiple criteria (excel 2003) 5
Need Help with a VBA subroutine 0
Financial Time Value of Money calculations 5
How do I clear a form? 0
Please help matching data from one table to another 4
how do i convert a flat rate into a reducing rate? 1
Deleting records from a table 3

Top