problem with this "IF"

G

gbeard

=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
 
R

Ragdyer

Try this:

=IF(INDIRECT("'"&B$1&"'!"&"C2"&ROW(A2))<B$3,(INDIRECT(B$1&"!A"&ROW(A2))))
 
Top