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))

=index(f3:f7,match(1,(a3:a7=670000)*(b3:b67=640),0 ))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Mark" wrote in message
...
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))