row and cell reference

[tjh]

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?

 

[Duke Carey]

One way

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

where the range in both functions is the same