Exact Match Function Based on Letter Case

[Steve=True]

Hello All,

Does anyone know if you can create a Match Function that only finds an Exact Case match?

My Data has records thar are unique in the system, but may not appear unique in excel matching terms.

Record 1 ID: 0016000000g2upN
Record 2 ID: 0016000000g2upn

When performing an exact match, my formula returned the first record with a match, but not an exact match based on the case of the letters.

I need a non-VBA solution. Any help is appreciated. Thanks!

 

[c_m_s_jr]

TRY the following...

Excel Workbook
	A	B
6	0016000000g2upn	2
Sheet3

Got this from: http://www.atlaspm.com/toms-tutorials-for-excel/toms-tutorials-for-excel-case-sensitive-lookup/

 

[Rick Rothstein]

I think this array-entered** formula will work...

=MIN(IF(ISNUMBER(FIND(B1,A1:A100)),ROW(A1:A100)))

B1 is assumed to contain the text you want to match; adjust the column range to suit your data.

**Commit formula using CTRL+SHIFT+ENTER, not just Enter by itself.

 

[Steve=True]

Thank you both very much!

Do either of you know if there is a non-Array formula way without VBA?

Also, Rick is yours comparing the text as a number and that is why it works?

Thanks much!

 

[Teethless mama]

Thank you both very much!

Do either of you know if there is a non-Array formula way without VBA?

Also, Rick is yours comparing the text as a number and that is why it works?

Thanks much!

Excel Workbook
	A	B	C
1	A	b	4
2	B		4
3	C
4	b
5	E
6	F
7	G
8	H
9	I
Sheet1