Return value based on criteria in a chart

[Rportz]

If I enter the number of family size, I want the cell to return "Qualified" if the Income is no greater than the income that correlates with the Number in Household (refer to chart) otherwise return "not qualified." For instance, if I enter Family Size of 2 and enter the income as $15,000.00, then the cell returns "Qualified" because $15,000 is less than the $16,460 (see chart). If I enter family size of 2 and enter income as $20,000, then the cell returns "Not Qualified"

Chart:

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Family Size
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Income
[/TD]
[TD]$12,140
[/TD]
[TD]$16,460
[/TD]
[TD]$20,780
[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Enter Family Size:
[/TD]
[TD]2
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Enter Income:
[/TD]
[TD]$15,000
[/TD]
[TD]"Qualified"
[/TD]
[/TR]
</tbody>[/TABLE]


I appreciate any help you can provide on this

Rita

 

[tuple1020]

I would use an IF formula.

=IF(income entered<=HLOOKUP( family size entered,B1:D2,2,FALSE),"Qualified","Not Qualified")

The HLOOKUP range of B1:D2 is assuming that the 1,2,3 family size numbers are in row 1, with "1" starting in B1, and that the income is directly beneath it.

 

[Rportz]

This worked perfectly!! Thank you so much.