View Single Post
  #2   Report Post  
Duke Carey
 
Posts: n/a
Default

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?