I need to get a vlookup to match on case here is an example of two different IDS a#A3A00000AQkRp a#A3A00000AQkRP when I do the vlookup it returns the second value which isn't an exact match but I've tried to use the exact match features but it never seems to work with vlookup.
Solved by E. L. in 20 mins