Finding Nth Occurence of a sub-string

[Scott Cooper]

Hi All,

I currently use this a variation of the formula {=INDEX($C$1:$C$51,SMALL(IF($A$1:$A$51="Adeline",ROW($A$1:$A$51),""),3),1)} to find the Nth occurrence of a value.

I need some help adjusting this to find the nth occurrence of a value if it exists within a string. For example if I was looking for the word ME it should flag up if the text in a cell is MEET rather than just ME.

any help would be appreciated.

 

[Chihiro]

Use wild card like "*ME*".

If that's not what you are looking for, upload sample file with expected result please.