Hi, finally back. I think that is what looking for. not that quick at some
formula's though, tried:

=IF(ISNA(MATCH("X",$AU$68:$AU$1097,0)),"",MATCH("X ",$AU$68:$AU$1097,0))

to get rid of na error, worked, but when put an "x" in the column, got an
off answer, wrong line returned.

part2: was working on tool to make it into a hyperlink to that line, might
be able to figure it out, with INDIRECT? thanks

"Toppers" wrote:

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