• Lookup trivia… (XL 2003 UK)

    Author
    Topic
    #445841

    Hi,

    Probably a trivial one…

    Got two columns:
    ‘A’ holds name of countries: US, UK, Spain, Denmark, Italy, Portugal, Netherlands etc…
    ‘B’ holds short equivalent ISIN codes: US, GB, ES, DK, IT, PT, NL…

    Together this gives a sorted range from A1-B7 (sorted ascending by col ‘A’)

    In columns D and E rows 1-4 I have the following:
    D1, value: ‘ISIN’
    D2, formula: =VLOOKUP(E2,A1:B7,2,FALSE) (This is the result of the ‘Country lookup)
    D3, value: ‘ISIN lookup’
    D4, validation list. (set to: ‘List’, Source: =$B$1:$B$7)

    E1, value: ‘Country lookup’
    E2, validation list. (set to: ‘List’, Source: =$A$1:$A$7)
    E3, value: ‘Country’
    E4, …????? (This should be the result of the country lookup)

    My problem is that Excel looks in the leftmost column and that the data I am looking up not are placed in the leftmost of the two columns.
    – I am hoping that there are a simple work around for a situation like this…

    Bests and thanks in advance,

    Viewing 1 reply thread
    Author
    Replies
    Viewing 1 reply thread
    Reply To: Lookup trivia… (XL 2003 UK)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: