Storing a vba lookup in an array

[erikhs]

Hi,

I would like to do the following:

From an array populated by country codes i would like to lookup the
country name in a named range on the form: CountryCode CountryName,
i.e. the second column. Then for each country code in the first array,
the found name should be stored in another array. Why wont this work
f.x.:

For i = 1 to whatever
CountryNames(i) = Application.Match(CountryCode(i),
CountryCodeArrayRange, 0).Offset(0, 1).Value
Next i

I might be making som "obvious" mistake, so please tell me if so!

 

[Guest]

Try:

For i = 1 to whatever
CountryNames(i) = Application.VLOOKUP(CountryCode(i),
CountryCodeArrayRange, 2,0)
Next i

HTH