| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Case Sensitivity in Lookup Functions
Thanks Jan, this was most helpful!
"Jan Bolluyt" wrote: There are three ways to check the value and case. See http://office.microsoft.com/en-us/ex...561301033.aspx Hope this helps JB "TISI-84601" wrote in message ... Is there a way to perform case sensitive lookup functions? For example...I am trying to perform a vlookup on a cell with a value of 'dDqf'. Unfortunately my table array contains cells in the lookup column that have values of both 'dDqF' and 'dDqf' and the lookup function doesn't seem to differentiate based on upper/lower case and therefore returns the 'dDqF' value instead of the 'dDqf' value that I need it to. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to perform caculations using database functions in this case | Excel Discussion (Misc queries) | |||
| How to change case of text without using functions? | Excel Discussion (Misc queries) | |||
| VLookup & Case Sensitivity | Excel Worksheet Functions | |||
| Pivot Table Heading Fields - case sensitivity issue | Excel Discussion (Misc queries) | |||
| Case Sensitivity problem with data validation | Excel Worksheet Functions | |||
![TISI-84601[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
