LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
count colored cells? DKY Excel Worksheet Functions 21 January 19th 06 09:47 PM
VBA Code Cell Mate Excel Discussion (Misc queries) 4 January 9th 06 08:52 PM
convert numbers to text bellman Excel Discussion (Misc queries) 0 October 4th 05 10:28 PM
How to .. sbgvp Excel Discussion (Misc queries) 8 October 4th 05 09:16 PM
Spellnumber Norman Jones Excel Worksheet Functions 6 December 13th 04 07:21 AM


All times are GMT +1. The time now is 06:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"