Drag formula 1 column but have it search a column 12 columns over?

=MIN(IF(ISNUMBER(SEARCH(A214,$A$1:$A$150)),ROW($A$1:$A$150)))

This is the formula I am using, but cannot figure out how to incorporate Offset function to search column N instead of A.
This formula is in A200 but need it so when I drag to B200 it searches N1:N150 and still holds the search text in A214.

Thank you.

This works for going to B, I should have explained further but basically i have a couple dozen sets of data and i need to know what row a certain word shows up in in each set. the word is always spaced 12 columns apart but there is no consistency of what row they show up in.

Originally Posted by Glenn Kennedy

See Post 3. However, note that columns A and N are 13 columns apart... Adjust the ZZ to whatever is needed.

=MIN(IF(ISNUMBER(SEARCH($A214,INDEX($A$1:$ZZ$150,,1+13*(COLUMNS($A200:A200)-1)))),ROW($A$1:$A$150)))

Gotcha this worked amazing, thank you very much

Originally Posted by Glenn Kennedy

You're welcome. Thanks for letting us know that you got an answer.

---

Please take a moment and consider clicking the "Add Reputation" button at the foot of any of the posts of anyone who helped you reach a solution here today.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

Apologies for commenting on a solved post, I was just inquiring about whether there is any way to edit to count the nth instance of what it is searching. So the same exact text in A214 but the second and or third instance of it.