Dragging the =INDIRECT Formula

[snowdyce]

Hello experts,

I have an excel sheet that is linked to a database. I have noticed when I Refresh Data from the database, my excel formulas that are referencing that data would lose the cell, resulting in a #REF error. To get around this I have been using the =INDIRECT formula. My question is, is there an easy way to drag and auto fill the cell reference using this formula? I have about 1,000 rows, and do not want to hand type each one.

Example Cell A2: =INDIRECT("B2")

I want to drag that down to A1000 and the formula to change accordingly (=INDIRECT("B1000")). When I attempt, its stays at B2 because it is text.

Anyway around this?

Thanks!
Sean

 

[JoeMo]

Try:

=INDIRECT("B"&ROW())

 

[snowdyce]

Thanks Joe, that worked perfectly!

 

[JoeMo]

Thanks Jo, that worked perfectly!

You are welcome - thanks for the reply.