use row numbers from a list in subsequent formula

[Guest]

Is there a straightforward way to scan thru a column and identify each row
numer that contains a specific value in the column? The column is not in any
sort sequence. I waant to use the row numbers obtained as input to a formula
afterwards.
Thanks.

 

[Trevor Shuttleworth]

You could use MATCH

For example:

=MATCH(B1,A:A,0)

looks for the value in cell B1 in the cells in column A and returns the
relative position.

So, if you had a, b, c, d, e, ... in cells A1, A2, A3, A4, A5, ... and c in
cell B1 it would return 3

If there are multiple cells with c in them it would be more complex ... and
the answer might depend on how you wanted to see the output.

Regards

Trevor