excel - Using a string key to return a value from an array -


i have named array of 14 rows 2 columns. first has string key (ie: country), , second attribute (ie: owner). want retrieve owner supplying country.

i know how use =index retrieve values named arrays, expects col/row numbers.

how might achieve requirement?

for sake of answer.

feed index function match function provide requisite row number, along lines:

=index(b:b,match(a2,a:a,0)) 

vlookup work index/match more powerful (see) if comfortable index might better add match arsenal rather bother v/h lookup.


Comments

Popular posts from this blog

php - regexp cyrillic filename not matches -

c# - OpenXML hanging while writing elements -

sql - Select Query has unexpected multiple records (MS Access) -