Excel VLOOKUP ignoring case
Posted on 2001-08-28
I'm finding that Excel apparently sees the difference between 00011AB and 00011Ab when sorting, but when I then do a VLOOKUP, if the lookup value is 00011Ab, it returns info from the 00011AB row (which comes first).
Is VLOOKUP not case-sensitive? Can I make it case-sensitive?