Excel MATCH () function always gives # N / A

Question

A super simple match is as follows:

=MATCH("Team", A1:A25,0)

Data in A1: A25 is imported from a text file. Cells are formatted as text.

If I enter the column and manually type “Team” into the cell that already says “Team,” then it will work. But if I did not manually enter it, it says # N / A.

What is wrong with that?

Answer 1

One problem may be that you have unwanted empty characters (I mean a space) before or after the word (so this is “Team” instead of “Team”). A dirty workaround will crop the text as follows:

{=MATCH("Team", TRIM(A1:A25),0)}

(, , Ctrl + Shift + Enter)

Answer 2

A1: A25, .

B A.

Cntl-, B.

, , .

b: = trim (A1) .

, (.. ).

.