View Single Post
  #1   Report Post  
Dan in NY
 
Posts: n/a
Default any way to make vlookup case sensitive?

I'm using vlookup for translating a code into a decode value. The codes are
in both lowercase and uppercase, unfortunately with the same values (e.g.,
cnv and CNV represent 2 different things). Anyone know how to make vlookup
case sensitive? Or is there another fancy excel function that can provide
the equivalent functionality?

Thanks!