Try this:

=IF(INDIRECT("'"&B$1&"'!"&"C2"&ROW(A2))<B$3,(INDIR ECT(B$1&"!A"&ROW(A2))))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"gbeard" wrote in message
...
=IF(INDIRECT(CONCATENATE("'"&B$1&"'!"&"C2"&2))<B$3 ,(INDIRECT(B$1&"!A2")),)

When I copy this formula down a column I need the A2 at the end to change
to
A3, A4... I also need the 2 before the < to increase by one in each row
down.
What is keeping these from increasing as I copy them down the column?

Thanks for any insight,
Gary "Excel Rookie" Beard