I'm trying to perform a simple operation on a block of data. The start and end are variables, always in column A but could be any row. I have used =match on my Data sheet to find the start easily enough, based on specific text: =match("start",Input!A:A,0) which returns a number, in this case 19.

Now I want to find the end of the block, which is a blank cell. There are blanks before the start aswell, so I need to start searching on the Input sheet, range A<result of last match, in this case 19>:A999.

I've tried nesting but I keep getting a #name error. What's wrong with this formula?

=match("",Input!A(value(Data!A1)):A999),0)

That should translate as =match("",Input!A19:A999),0) shouldn't it?