In B6 of the Currency Exchange worksheet, use a VLOOKUP function to look up the Country Traveling To, and return the country's Exchange Rate for $1.00 US from the table on the Currency Table worksheet.
Then, once you have that VLOOKUP function complete, multiply the VLOOKUP function x the US Dollars to Exchange (from the Currency Exchange worksheet). This will calculate the amount due based on each country’s exchange rate. Be sure to use absolute cell references where necessary.
Copy this formula to cell D6.
Change the monetary symbol accordingly for each country's conversion (using the Euro € 123 format for Germany).
Solved by I. F. in 17 mins