Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use Match or Vlookup? | Excel Discussion (Misc queries) | |||
help vlookup,match | Excel Worksheet Functions | |||
vlookup, match? what do I use? | Excel Worksheet Functions | |||
To VLOOKUP more than one possible match | Excel Discussion (Misc queries) | |||
Match or VLOOKUP | Excel Worksheet Functions |