Relative reference won't update

L

LaborGuyRJ

Hello,
I've got a row of about 8 formulas and contain and absolute and a relative
reference in it to another worksheet.
My problem is this:
A1 contains =INDIRECT("Database!$F2") and the rest of the column is
similiar.
I would like for the formula in A2 to increase to $F3 automatically as i
drag the formula's down, and continue for about 100 columns. This isn't
happening.

I get the exact same formula all the way down. Can anyone give me a hand
please. Thanks
BOB Reynolds
 
P

Pete_UK

Your F2 is inside the quotes and is therefore treated as a string and
does not increment. Try this instead:

=INDIRECT("Database!$F"&ROW(A2))

and then copy it down as required.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change a cell reference from relative to absolute 2
Range of cells: Convert relative reference into absolute 5
Relative worksheet reference clarified 4
Copying formulas, relative and absolute cell references 3
convert relative cell references to absolute cell references via amacro? 1
Filling Formulas 2
A "relative" absolute cell reference? 6
How to convert relative to absolute addressing instantly in Excel 3

Top