Not quite... unless I'm doing it differently than you intended (and I
probably didn't explain it well). eg, 1 person, =1300 income, R result. But
in your equation if I have 1 person, and 1305, I still get the F as a result.
At that point I need it to give me the R. Essentially, depending on the
number of people, and thier household income, they end up in one of three
categories: F, R, or D for denied.
Thanks for your quick responses though.

"Luke M" wrote:

There's probably a way to do this more efficiently, but this worked for me:

=IF(ISERROR(INDEX(C2:C7,SUMPRODUCT((A2:A7=D2)*(B2: B7=E2)))),"D",INDEX(C2:C7,SUMPRODUCT((A2:A7=D2)*( B2:B7=E2))))

Number of people in households listed in D2, income listed in E2.

Hope it helps!
--
Best Regards,

Luke M


"ahwahneeliz" wrote:

What bothers me the most is I had this before, but the file got deleted.
Anyway,
By entering a number in each of two cells, I need to look up an exact
quantity (number of people from 1 to 8) from column 1, a less than or equal
to value from column 2, and display the matching item from column 3. If you
need to make more columns or whatever, feel free. This is simply a table for
people who qualify for a lunch program. If there are a certain number of
persons in the household, and the household earns less than X$, then they
qualify for F, R, or D do not qualify. I don't mind if it looks up for the D
value, or just assumes the D value because of a false result.


a1 a2 a3
Persons in House income category
1 1100 f
1 1300 r
2 1250 f
2 1400 r
3 1350 f
3 1680 r
and so on.
Thanks in advance. I've been pulling my hair out trying to recreate the
formula.