[Row Name]MATCH



I want to refer to a Range that is the CHILDREN of a certain row, but the row number will move around depending on adding/deleting rows. I'm hoping to use MATCH to search for a unique string to return the row number.

I know that a traditional cell reference such as [Column Name]Number will adjust if I add a row, but it makes copy/paste add or subtract when copying.

If I use a static reference [Column Name]$Number, then the copy/paste works but it breaks when we add a cell.

Is it possible to send the output of another function to the row number portion of a cell reference?

Something like

[Column Name](MATCH(Search Value, Range, 0))

How do I get a function to put the row number there? I'm missing some syntax.


Mark V


Best Answer