Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Case Sensitive Compare, Lookup, etc????
I'm a current Excel 2003 user and been frustrated with its in ability to do
comparisons on Ascii values correctly. I have come up with different hoop jumping techniques but I'm getting old and tired. Can anyone tell me if this issue has been resolved in 2007. I would upgrade for that reason alone! Example: I need to discern the difference between 00Q3000000FHYdGEAX and 00Q3000000FHYDGEAX (upper and lower case "d" is the difference) in a Vlookkup or compare, etc. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Case Sensitive Compare, Lookup, etc????
Won't the Exact function do it for you? -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "GSkerm" wrote in message I'm a current Excel 2003 user and been frustrated with its in ability to do comparisons on Ascii values correctly. I have come up with different hoop jumping techniques but I'm getting old and tired. Can anyone tell me if this issue has been resolved in 2007. I would upgrade for that reason alone! Example: I need to discern the difference between 00Q3000000FHYdGEAX and 00Q3000000FHYDGEAX (upper and lower case "d" is the difference) in a Vlookkup or compare, etc. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Case Sensitive Compare, Lookup, etc????
This is one of the work arounds if I need to do a simple compare, but it
can't be used (or should I say I don't know how to use it) with a VLOOKUP or if I use it in a pivot table or if I do a find. "Jim Cone" wrote: Won't the Exact function do it for you? -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "GSkerm" wrote in message I'm a current Excel 2003 user and been frustrated with its in ability to do comparisons on Ascii values correctly. I have come up with different hoop jumping techniques but I'm getting old and tired. Can anyone tell me if this issue has been resolved in 2007. I would upgrade for that reason alone! Example: I need to discern the difference between 00Q3000000FHYdGEAX and 00Q3000000FHYDGEAX (upper and lower case "d" is the difference) in a Vlookkup or compare, etc. Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Case Sensitive Compare, Lookup, etc????
A Dictionary object will discern between upper/lower case. However that requires VBA or VBS programming code. I am not aware of any changes in the Vlookup and Match functions in xl2007. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "GSkerm" wrote in message This is one of the work arounds if I need to do a simple compare, but it can't be used (or should I say I don't know how to use it) with a VLOOKUP or if I use it in a pivot table or if I do a find. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Case Sensitive Compare, Lookup, etc????
Also... "Find" has a match case option. Jim Cone |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Case Sensitive Compare, Lookup, etc????
if your data is in A1:B6 and E1 contains the value to look up, try:
=INDEX(B1:B6,MATCH(TRUE,EXACT(A1:A6,E1),0)) array entered with Cntrl+Shift+Enter. If done properly, XL will put braces { } around the formula "GSkerm" wrote: This is one of the work arounds if I need to do a simple compare, but it can't be used (or should I say I don't know how to use it) with a VLOOKUP or if I use it in a pivot table or if I do a find. "Jim Cone" wrote: Won't the Exact function do it for you? -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "GSkerm" wrote in message I'm a current Excel 2003 user and been frustrated with its in ability to do comparisons on Ascii values correctly. I have come up with different hoop jumping techniques but I'm getting old and tired. Can anyone tell me if this issue has been resolved in 2007. I would upgrade for that reason alone! Example: I need to discern the difference between 00Q3000000FHYdGEAX and 00Q3000000FHYDGEAX (upper and lower case "d" is the difference) in a Vlookkup or compare, etc. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Case sensitive filter | Excel Worksheet Functions | |||
Validation ... Case Sensitive? | Excel Discussion (Misc queries) | |||
Case sensitive filtering | Excel Discussion (Misc queries) | |||
Getting a case sensitive match? | Excel Worksheet Functions | |||
Case Sensitive w/ IF | Excel Worksheet Functions |