vlookup to match
 

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 :)

--
oldLearner57

vlookup to match
 

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 = %

--
Biff
Microsoft Excel MVP


"oldLearner57" wrote in message
...
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 :)

--
oldLearner57

vlookup to match
 

10s :) T. Valko


10s community as well

--
oldLearner57


"T. Valko" wrote:

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 = %

--
Biff
Microsoft Excel MVP


"oldLearner57" wrote in message
...
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 :)

--
oldLearner57

vlookup to match
 

You're welcome!

--
Biff
Microsoft Excel MVP


"oldLearner57" wrote in message
...
10s :) T. Valko


10s community as well

--
oldLearner57


"T. Valko" wrote:

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 = %

--
Biff
Microsoft Excel MVP


"oldLearner57" wrote in message
...
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 :)

--
oldLearner57