I'm not sure what you mean by "contingent cells", but I'm guessing you mean "contiguous" instead. "Contingent" means "dependent"; a "contingent fee", for example, means a fee that may or may not be imposed depending on other circumstances. You, I suspect, mean cells that are next to each other, right?
I may have done you a disservice by replying without offering a solution; some people will see that there's a reply (mine) and assume there's no need to look at your question. But maybe also they'll look at your question, not understand it and not answer it for that reason. If no one replies now, maybe repost the (corrected) question.
Off-hand I'm not sure how I would do this. Or, hm, maybe I can think of a way. If you create a helping column that concatenates the three cell values (one row above, this row, one row below), you can then search that column for the concatenated string. Would that help? I can explain better if it's not clear what I mean.
|