Case specific LOOKUP alternative
Do you need to use lookup- would not the CODE function return the value you
want?
"dan" wrote in message
...
Is there an alternative to the V/H LOOKUP worksheet functions which is
case
specific?
If not can anyone suggest a way to have a case specific alternative
comment?
for example I am trying to create an ASCII lookup table with two columns.
The characters in column A and the ascii number in column B so that I can
use
a VLOOKUP in another sheet. However I need to be able to distinguish
between, for example 'f' and 'F'.
Thanks in advance
|