Hope this partially helps.

[Steve]

use vlookup on the part if Loan = x the this other cell = y

Example
A B
1 LoanA .25
2 LoanB .30
3 LoanC .40

If for example cell D12 = LoanC then in E12 you could put
=vlookup(D12,A1:B3,2) This will return .40

I did not have time to look at the rest of your question.

 

[JE McGimpsey]

Since you didn't reply to the original message, and since you changed
the Subject line, it will only be by pure luck that this helps the
person you intend to help.

Always use the Reply button, and never change the subject (other than to
make it Re: <original subject>, as this message does).