Hi All,
I'm having trouble creating a formula that will reference customer table [see below] that has 3 criteria and using those 3 criteria matching them up to a currency FX table [see below] I have where i want to drop in the currency found in the table based on the 3 criteria in the customer table.
So in this case, i want the correct currency to be added to the right of the "currency" column in the customer table, coming off of the FX table below. The FX table can change layout below, the customer table cannot due to having 10000+ rows.
Any Suggestions? Thanks!!
Customer Table
Year Quarter Currency
customer 1 2015 1 GBP
customer 2 2015 3 USD
customer 3 2013 4 CAD
customer 4 2014 2 GBP
customer 5 2013 4 USD
customer 6 2012 2 GBP
customer 7 2012 1 GBP
customer 8 2013 3 USD
customer 9 2014 3 CAD
FX Table:
Year 2013 2013 2013 2013
Quarter 1 2 3 4
CAD 1 1 1 1
USD 1.0082 1.0232 1.0392 1.0492
GBP 1.5653 1.5717 1.6107 1.6985
EUR 1.3312 1.3363 1.3765 1.4282
Bookmarks