I have a cell that is Data/Validation linked to a column of ISO Currency Codes(eg USD, GBP), Next to the colum of currency codes I have a list of country names matched to their currency.
I am now trying to find a function(Vlookup, maybe ??) that looks at the currency selected by the user and then returns the name of the country in the adjacent cell ? :question: