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)

Array enter:

=INDEX(Sheet4!A1:F59,MATCH(TRUE,EXACT(Sheet4!A1:A5 9,B3),0),2)

(Array-entering means: hold down Ctrl and Shift before pressing Enter).

Please note that there shouldn't be a space between 5 and 9 in the first argument of the EXACT-function. It is due to some fault on this site.

Hi xor

Thanks for the reply i tried the formula but it just brings back true if it matches upper or lower case but im wanting it to bring back whatever is in the second column on sheet 4.

Hope this explains it a little better as I dont think I explained it to well in my original post.

Thanks again for the assistance on this

Please try to upload a sheet with what you have and what you want.