I am looking for the value when Loan amount is $670,000 with 640 FICO
and LTV 76 and that should give me 3.000
LTV 0 70.01 75.01 80.01 85.01 90.01
Loan Size FICO
$650,000.01 620 659 1.000 2.000 3.000 N/A N/A N/A
$650,000.01 660 0.000 0.000 0.000 0.000 0.000 N/A
$1,000,000.01 740 4.000 5.000 N/A N/A N/A N/A
$1,000,000.01 680 739 6.000 7.000 N/A N/A N/A N/A
$1,500,000.01 680 8.000 N/A N/A N/A N/A N/A
that's what I have and it can't seem to work
=INDEX(D3:I7,MATCH(B11,D1:I1,1),MATCH(B10&B9,A3:A7 &B3:B7,1),1)
I tried too but nothing
=INDEX(D3:I7,MATCH(B11,D1:I1,0),MATCH(B10&B9,A3:A7 &B3:B7,0))