|
|
#1
02-25-2017, 04:25 AM
|
|||
|
|||
formula isnt case sensitive please help
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) 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Why are message header rules are case sensitive | delboy | Outlook | 1 | 10-10-2023 11:30 AM |
 Lost Word Document and cant find it!!! I saved it but it ISNT there!!
|
APAV | Word | 9 | 10-09-2017 01:17 PM |
|
Need to extract all lines containing EA, EB, EC...EZ. (case sensitive)
|
Maxwell314 | Excel | 11 | 11-06-2015 08:52 AM |
| Case Sensitive (contains) Selection | apolloman | Excel | 2 | 07-12-2011 04:50 AM |
|
From all UPPER CASE to Proper Case
|
davers | Word | 1 | 04-30-2009 12:41 PM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode