=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

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

Thanks RD,
I'll see if that helps!

--
Gary Beard

RD,
Worked like a charm...I appreciate the help!

--
Gary Beard