Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Storing a vba lookup in an array
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! -- erikhs ------------------------------------------------------------------------ erikhs's Profile: http://www.excelforum.com/member.php...o&userid=32788 View this thread: http://www.excelforum.com/showthread...hreadid=567054 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Storing a vba lookup in an array
Try:
For i = 1 to whatever CountryNames(i) = Application.VLOOKUP(CountryCode(i), CountryCodeArrayRange, 2,0) Next i HTH "erikhs" wrote: 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! -- erikhs ------------------------------------------------------------------------ erikhs's Profile: http://www.excelforum.com/member.php...o&userid=32788 View this thread: http://www.excelforum.com/showthread...hreadid=567054 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use array for lookup value, to return array of lookups | Excel Discussion (Misc queries) | |||
Storing an array in a cell | Excel Worksheet Functions | |||
Lookup "greater than or equal to" in lookup array | New Users to Excel | |||
Storing text in an array | Excel Programming | |||
storing financial data in array | Excel Programming |