Data/Validation list.... SOLVED

  • 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:

  • A Vlookup would solve your problem


    Create a table of currency codes and then the corresponding country


    USD United States
    GBP Great Britain
    etc


    This range could then be saved as the name Country INSERT-NAME-DEFINE


    Assuming that the data validation for the currency is in cell B4 enter the following function in cell C4


    =VLOOKUP(B4,Country,2,FALSE)


    B4 refers to the lookup value
    Country is the name of the range, could also be entered as a range eg $G$1:$H$10
    2 refers to the Column in the range
    FALSE means find an exact match


    hope this helps

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!