Performing a Case-Sensitive IF search

I can't tell much from what's posted. A sample Excel workbook upload (no pics or screenshots ... saves retyping data). Just a small sample is usually sufficient ... 20-30 rows.

If you are not familiar with how to upload an Excel file:


To attach a file to your post,

• be sure to desensitize the data
• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Upload”
• click “Close window”
• click “Submit Reply”

The file name will appear at the bottom of your reply.

In the meantime have you tried FIND? It is case sensitive.

In J1 and filled down.

Formula:

Please Login or Register  to view this content.

	G	H	I	J
1	Kelly		Bob
2	JOHN		John	John
3	Joe		Mike	Mike
4	ELSIE		Jacob	Jacob
5	Sandra		Kelly	Kelly
6	PAUL		Martha	Martha
7	JOANNE		Joe	Joe
8	JOANNE		Rachel
9	Mike		Liz
10	Linda		Elsie
11	Steve		JoAnne
12	RACHEL
13	BOB
14	JEANNINE
15	John
16	Martha
17	Vince
18	SUSAN
19	Sandra
20	JOHN
21	Phyllis
22	JEANNINE
23	LINDA
24	MARTHA
25	Jacob
26	JOANNE
27	JOE
28	JOHN
29	LIZ
30	Joe

Try in BL13 and filled down.

Formula:

Please Login or Register  to view this content.