Need help with the formula please! Thanks!

Instructions: Update the direct exchange rates, highlighted in orange, in the Exchange Rate Table. Create formulas that will automatically update the indirect rates in blue. Enter the denomination and amount of currency in cells C7 and D7 Enter the new denomination for your currency in cell C9 Calculate the equivalent amount of the new currency using a lookup function Use data validation as appropriate and format to a common professional standard J28 fx A B D E F H 1 1 2 Noah Vail's Universal Currency Exchanger Rates current as of March 2, 2016 3 3 4 5 Amount My currency is in: I would like it to be in: 6 7 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Dollars Pesos Loonies Pounds Euros Exchange Rate Table Dollars Pesos Loonies Pounds Euros 1 17.81750 1 1.34550 13.23850 1 0.71112 25.04620 1.89120 1 0.92177 19.32910 1.45880 0.77136 1 33 34 35 36 37 38 Instructions: Update the direct exchange rates, highlighted in orange, in the Exchange Rate Table. Create formulas that will automatically update the indirect rates in blue. Enter the denomination and amount of currency in cells C7 and D7 Enter the new denomination for your currency in cell C9 Calculate the equivalent amount of the new currency using a lookup function Use data validation as appropriate and format to a common professional standard J28 fx A B D E F H 1 1 2 Noah Vail's Universal Currency Exchanger Rates current as of March 2, 2016 3 3 4 5 Amount My currency is in: I would like it to be in: 6 7 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Dollars Pesos Loonies Pounds Euros Exchange Rate Table Dollars Pesos Loonies Pounds Euros 1 17.81750 1 1.34550 13.23850 1 0.71112 25.04620 1.89120 1 0.92177 19.32910 1.45880 0.77136 1 33 34 35 36 37 38