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.