Dynamic number of ROWS
 

I need to search a sheet with 79 ROWS but this can vary.
I use do the search from another sheet. I am looking for
an exact match of a value in a particular Column C so I
use MATCH(D24,C2:C79,0)
This works ok and I take care of errors with ISNA. My
question is how can I allow for the fact that the number
of rows may be different without having to manually edit
the formula.

Use can create a dynamic range using OFFSET:

=MATCH(D24,OFFSET(C2,,,COUNTA(C2:C65536)),0)

HTH
Jason
Atlanta, GA

-----Original Message-----
I need to search a sheet with 79 ROWS but this can
vary.
I use do the search from another sheet. I am looking
for
an exact match of a value in a particular Column C so I
use MATCH(D24,C2:C79,0)
This works ok and I take care of errors with ISNA. My
question is how can I allow for the fact that the number
of rows may be different without having to manually edit
the formula.


.

This works fine, Jason,

Thank You

-----Original Message-----
Use can create a dynamic range using OFFSET:

=MATCH(D24,OFFSET(C2,,,COUNTA(C2:C65536)),0)

HTH
Jason
Atlanta, GA

-----Original Message-----
I need to search a sheet with 79 ROWS but this can
vary.
I use do the search from another sheet. I am looking
for
an exact match of a value in a particular Column C so I
use MATCH(D24,C2:C79,0)
This works ok and I take care of errors with ISNA. My
question is how can I allow for the fact that the number
of rows may be different without having to manually edit
the formula.


.

.