The MATCH function returns the first occurrence of a value so if the data was
in A1:A200 and the first occurence of "X" was in row 55, MATCH returns 55. I
am assuming we are comparing a cell value and not part of a string.

=MATCH("X",A1:A200,0)

Is this what you require?

"nastech" wrote:

was wondering if it is possible to have a formula tell you the next line
number / the first occurance of a letter, "x", in one column? thanks