row and cell reference
 

Hello,

I am using a match function to reference various cells. Is there a way to
use that match fuction with a row function to be able to tell me what the row
number of the cell is that I am looking up?

One way

=MATCH(value,range,0)+ROW(range)-1

where the range in both functions is the same


"tjh" wrote:

Hello,

I am using a match function to reference various cells. Is there a way to
use that match fuction with a row function to be able to tell me what the row
number of the cell is that I am looking up?