View Single Post
  #1   Report Post  
gbeard
 
Posts: n/a
Default problem with this "IF"

=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