Associate Name to Number

[rjwebgraphix]

Code isn't really need, I can figure that out, but looking for alternate ideas that might be better than what I'm thinking...

I need to associate a number to name. I was thinking about just using a simple array with a single string in each array element separated by a space. Left of the space is the Name, Right of the space is the number.

Most of the time it would only be a single association, but I need to account for multiple Names to their respective Number. A simple array in the fashion mentioned sounds the easiest, but I tend to forget about other common practices since I'm mostly all self-taught and just use it for side projects.

What do you think?

RJ

 

[Joe4]

Why not create a lookup table, of each name/number combination, and use VLOOKUP?

 

[JoeMo]

Other possibilities:
Two identically sized arrays, one holds the names (ArrNames), the other the numbers (ArrayNums) such that the number corresponding to ArrayName(i) is ArrayNum(i).

A two-column lookup table in a worksheet with Names and Numbers (say A2:B100 for example) and use a Variant (say V) as a 2-D array like this:
V=Range("A2:B100").Value. Then V(i,1) is a name with associated number V(i,2) and so on ....

 

[rjwebgraphix]

Other possibilities:
Two identically sized arrays, one holds the names (ArrNames), the other the numbers (ArrayNums) such that the number corresponding to ArrayName(i) is ArrayNum(i).

This could work better. The array count would also be the same if building them at the same time. Perfect. Thanks.

Edit: Maybe not, because I'll need to sort the array alphabetically by name, so they appear in the correct order when displayed and there's no way to keep that association as two separate arrays. :/ I guess a single array is the best way without going to a multi-dimensional array.

Why not create a lookup table, of each name/number combination, and use VLOOKUP?

For this purpose, code is better. No need to add data that is only used in code.

 

[JoeMo]

This could work better. The array count would also be the same if building them at the same time. Perfect. Thanks.

You are welcome - thanks for the reply.

 

[rjwebgraphix]

You are welcome - thanks for the reply.

Replied before thinking it through and added an Edit. :/ #crazyface

 

[JoeMo]

Replied before thinking it through and added an Edit. :/ #crazyface

In that case I'd be inclined to create a table in some out of the way place on a worksheet and use the 2-D variant array I suggested. Makes it very easy to add/remove names and to sort the names alphabetically.