What formula I need to use to find the value from a table using 2 criteria

[mrb89]

Hello! I'm new in this forum... please help me out to find the formula I need to use to find the value in column A (a5:a14) - using 1) Family Size "3" cell B1 and 2) Income $225 cell E1.
The formula has to reflect that the E1 ($225) should be between $154-$225. From looking at the table I know that the Rank# should be "2"
Thank you!

 

[KRice]

Welcome to the MrExcel forum! Here is one approach...this assumes the input Income needs to equal or exceed the table values, which are interpreted as lower thresholds for the various ranking tiers.

1650472859855.xlsx
	A	B	C	D	E
1	Family Size	3		Income	305
2		Result	3
3	â Rank \ Family Size à	2	3	4	5
4	1	$69	$77	$88	$102
5	2	$139	$153	$175	$203
6	3	$208	$230	$263	$305
7	4	$277	$306	$350	$406
8	5	$346	$383	$438	$508
9	6	$416	$460	$525	$609
10	7	$485	$536	$613	$711
11	8	$554	$613	$700	$812
12	9	$624	$689	$788	$914
13	10	$693	$766	$875	$1,016
Sheet1

Cell Formulas
Range	Formula
C2	C2	=LOOKUP(2,1/--(INDEX($B$4:$E$13,,MATCH($B$1,$B$3:$E$3,0))<=$E$1),$A$4:$A$13)