vlookup to match

[Guest]

hi community

can assist on this task ...

i created say, few columns of ascii char code and wish to use a lookup to
get the ascii code

scenario:

A B C D E
1 33 ! 72 H

2 35 # 73 I

3 37 % 74 J

4 40 ( 75 K

how can i create a vlookup() to get the char code as now my table array of
info that i want are found in different columns ?



thanks community for the help

 

[T. Valko]

You don't necessarily need a lookup table to do this. You can return the
character by using the CHAR function.

A1 = code number = 37

=IF(A1="","",CHAR(A1))

Result = %

 

[Guest]

10s T. Valko


10s community as well

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

10s T. Valko


10s community as well