Results 1 to 6 of 6

Copying down an indirect formula

Threaded View

  1. #1
    Registered User
    Join Date
    04-19-2009
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    21

    Copying down an indirect formula

    How can I copy down an indirect formula? When I copy it the lookup reference doesn't change.

    My formula is:
    =IF(INDIRECT("Q1")="",INDIRECT("R1"),INDIRECT("Q1"))

    but when I copy down the cell reference stays the same (I need to keep the indirect formula because I'm adding columns in column Q but it needs to reference column Q even when columns are added). From reading through some other posts I believe I need to add a ROW() or COLUMN() formula in there somewhere.

    Anyone run into this before? Any ideas?
    Last edited by sable; 08-20-2009 at 10:12 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1