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.
.
|