Too many variables? How can I fix this?

[rbrian]

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?

[Pepe Le Mokko]

You could define your range as

=INDEX(INDEX(A:A,match("start",input!a:a,0):INDEX(A:A,MATCH(9.99999999999999E307,A:A)))