View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dan
 
Posts: n/a
Default Case specific LOOKUP alternative

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