View Single Post
  #1   Report Post  
alan
 
Posts: n/a
Default can vlookup be forced to make a case sensitive match?

i have data that is case sensitive, and a vlookup function needs to
differentiate between for examle two values like 'tree' and Tree'.

is it possible to force the vlookup function to match case? thanks