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,