[Row Name]MATCH

itsnotbroken

Hello,

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.

Thanks,

Mark V

Bassam Khalil

Hi @itsnotbroken

Hope you are fine, please check the following post Work Breakdown Structure (WBS) i hope that you will find what you need in it.

Bassam Khalil

Hi @itsnotbroken

Hope you are fine, please check the following post Work Breakdown Structure (WBS) i hope that you will find what you need in it.

itsnotbroken

That is fantastic! Thanks

Bassam Khalil

@itsnotbroken

You are welcome and I will be happy to help you any time.