formula isnt case sensitive please help

		Microsoft Office Forums > Microsoft Excel > Excel
formula isnt case sensitive please help

02-25-2017, 05:55 AM

xor

Windows 10 formula isnt case sensitive please help

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

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).

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:02 AM.