I'm trying to find the positions of the values(text) in one column in another column. I ran the function: =MATCH(B1, A:A, 0)
and I get a #N/A
result. But this result is incorrect...as I clearly see the value of B1 in column A.
I thought the issue might be with the fact that I pasted the cells into the sheet. So I did a test run where I manually inputed the values in the cells and then ran the function. Result: It worked.... But I sure as hell don't want to manually input all my data.
So my question is...how do I fix this? I've tried pasting the values in all sorts of formats and still no luck. Maybe this is not the issue? I do not know. Suggestions will be greatly appreciated.
=MATCH("*"&B1&"*", A:A, 0)
should give a match. But that means that the text B1 can be anywhere in the cells you're looking up (*
is a wildcard in excel to mean any number of any characters).