Autofill based on User selection - two data sets

Good day everyone. This is likely a no-brainer for most but a mind-boggler for me. I have a data template that multiple users access to build their annual budget request. In this template, I have two data lists for this section. The first is location (site). The second is Currency.

I would like for Currency to be populated based upon the corresponding Location. The data tables are complete and aligned right now. You can find the tables in 'Tab 15.) Capital Investment, CA273:CB335. Please see attached file.

Your guidance is appreciated.

Thank you for your response. Perhaps I did not explain my need clearly. Let's say you are the project manager at the Valencia site. You are going to build you budget request for me for 2015. To do that, you will be using this template. In the template, there is a drop down for Location. When you select the site Valencia, the Currency would ideally autopopulate the CURRENCY designation cell from the list in the background. Once the Budget Exchange Rates are published in May, I will be linking the BER for each currency and will therefore need to do this again.

I hope this helps you understand my request a little better.

Thank you.