Looking to build a function exactly like MATCH(), except that it would
evaluate the text of comments in a range.

If any comment in that range contained specific text in one cell, say
"MyText", then the function would return the column number of the cell in the
lookup range that contained the criteria comment text.

Example:
=MatchCommentext(criteria,lookuprange)

This function would go in cell a1.
In b1 would be the criteria ... MyText.
The lookup range could be b2.e2.
Cell c2 in the lookup range contains a comment with the same text as the
criteria cell [b1].
Therefore the function in this example would return a value of 2.

** Would a simpler variation be that it returned a value of TRUE or FALSE?
That would still work.

Thank you in advance for looking at this.


- Mike