Hi All

I have a very basic formula just looking between at 2 columns of data but need it to spot the difference between upper and lower case entries as I have s and S and t and T and this has stumped me.

Below is my current vloopup which works fine for what im doing apart from when it hits upper and lower case it just picks the first one it sees. Is this something cthat change be corrected within my formula or will i possibly have to go down a different route?


=VLOOKUP(B3,'sheet4'!A1:F59,2,FALSE)