need help to do a look up function base on 2 criteria in two table

[duc thai]

need help to do a look up for % of FPL base on family size and income
FPL_match.PNG

[Gregb11]

It's always best to attach a sample file (see yellow banner at the top). Failing that, you can try this in J2 and copy down:

=SUMPRODUCT(($A$2:$A$100=H2)*(I2>=$B$1:$B$100)*(I2<=$C$1:$C$100)*($D$1:$D$100))

[duc thai]

hi Gregb11 i paste the formular on j2 and i got #value in return

[Gregb11]

Oops, I included cells in first row by mistake. Now that I see your table name, use this in J2 and copy down:
=SUMPRODUCT((FPL[family size]=H2)*(I2>=FPL[min])*(I2<=FPL[max])*(FPL[FPL]))

[duc thai]

hi Gregb11 thanks so much work perfect
can you give me the formular if it without the table name
use the range method

[Gregb11]

The 100 number below would be whatever row your data ends at.

=SUMPRODUCT(($A$2:$A$100=H2)*(I2>=$B$2:$B$100)*(I2<=$C$2:$C$100)*($D$2:$D$100))