View Single Post
  #1   Report Post  
Tawe
 
Posts: n/a
Default Case sensitive vlookup


Excel treats uppercase and lowercase text as equivalent in a vlookup.

Does anyone know how to avoid this, so that a vlookup formula doesn't
treat uppercases and lowercases text as equivalent ?

eg. the vlookup of "a" should give a different result than a vlookup
for "A".


--
Tawe
------------------------------------------------------------------------
Tawe's Profile: http://www.excelforum.com/member.php...o&userid=24242
View this thread: http://www.excelforum.com/showthread...hreadid=378512