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?