VBA (Excel) question 1

[jimbackus]

The company I work for uses a 3 character string to identify users. I want to convert the 3 character string to a full name. e.g. user identifier = xqj user full name = Tommy Atkins.

Assuming I populate one array with the identifiers and another with the full names is the only way to achieve the lookup to use a For loop?

Any suggestions for a more elegant solution welcome.

 

[SkipVought]

hi,

On a sheet...
[tt]
Code FullName
xqj Tommy Atkins
skv SkipVought
...
[/tt]
Using Named Ranges on the sheet...
[tt]
=INDEX(Code,MATCH('skv',FullName,0),1)
[/tt]
returns SkipVought

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}