Cell reference from drop down list

Hello Excel Wizards.

I need assistance in trying to solve this Excel Question. What is the formula in excel where the cell in reference return a value from a drop down list?

For example: I have a drop down list of HomeLoan Programs with rates from 3 different channels. If I choose a 30yr FNMA with rates 3.875 = 100.125 ; 4.00 101.250; 4.125 = 102.00

If I choose 20yr FNMA it will return the pricing to the cell next to the program.

I provide a spreadsheet.


30yr FNMA works from the drop down but all other programs does not work. I am not sure if I have to reference and index or match.


0

thanks for your help, I worked for the first row in each program but I need the two other rows below.