Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|