ascii code conversion table?

[TomYC]

I have a list of codes, each one of which identifies an institutional address, thus:
'A' is in the first column and that tells me that the person whose name is in the second column has an address of '6MON' and so forth. So my first worksheet (Names) contains two columns, one of address codes and one of names.
I have a second, code conversion table (worksheet) with one column of 80 single characters and a second column with 80 addresses. These 80 characters include both upper and lower case characters, as well as typewriter punctuation characters.
So I want to use some kind of lookup function in Excel to look at the address code, look up its corresponding address in the code conversion table, and return the address for the name in the list.
Which is the best procedure, avoiding the upper/lower case, etc., issues?

 

[SkipVought]

Hi,

I'd use the CODE function to display the code in your lookup table.

Then lookup the code, using the MATCH function, returning the column you want, using the INDEX function.



Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[yogia]

Hi TomYC:

In addition to the suggestion by SkipVought of using the CODE function, you may also consider alternatively using the FIND function, or the EXACT function along with the use of the MATCH and the INDEX functions.

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com