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?
|