Match function won't return correct row number

[Shaffness]

I have a weird problem I'm trying to auto populate to one sheet from another sheet and have run into a problem where it won't return the row number. I'm using a test function "=MATCH("durric",B:B,0)" on the sheet I'm trying to get the info from and looking directly at the matching string but the info that shows up is always #N/A. There are no duplicates and the column is even sorted(which doesn't help because I will need to index and match the info for the other sheet. I will also need to update this sheet and move around the data i'm searching through) if I take out 0 as the match type it will return the row# - 1 for this particular search and many others but some searches come up correct too. If I sort the sheet any other way all hell breaks loose. I've even tried pasting the data into a new sheet and the exact same thing happens. The data was copied over from a google sheet so I don't know if this is part of the problem either. I hope someone here will be able to point me in the right direction.

[dluhut]

check if there's a leading or trailing space of the word 'durric'.

That could be the reason why

[Pete_UK]

If you use MATCH with zero as the final parameter, it will look for an exact match, and if there isn't one then it returns #N/A. Perhaps you have leading or trailing spaces in the values in column B, and so there is no exact match with "durric". You can try it like this:

=MATCH("*durric*",B:B,0)

where the asterisks are wildcard characters so you are looking for "durric" to be contained within any of the cells in column B.

If you remove the zero from the MATCH function then the data in column B has to be sorted (and it doesn't seem as if it will always be sorted) and then it will carry out an inexact match on the value which is the nearest (lowest) value to the one sought - this can produce some unexpected results, especially with strings.

Hope this helps.

Pete

[Shaffness]

Oh my god such an easy fix, thank you both, now I feel like a dummy.