+ Reply to Thread
Results 1 to 2 of 2

Trouble joining a formula to be direct and indirect

  1. #1
    Registered User
    Join Date
    04-27-2011
    Location
    Dallas
    MS-Off Ver
    Excel 2003
    Posts
    1

    Trouble joining a formula to be direct and indirect

    I have a formula that references a cell in a different sheet called "allocation". I want to be able to copy the formula into a new workbook and have it reference the same sheet name ("allocation") in the new workbook. I'm using this formula so far:

    =INDIRECT("'allocation'!A10")

    This works but I also want it to change the A10 as the formula is copied down a column.
    The INDIRECT formula stops that from happening. How can I combine the indirect reference to sheet name but allow a10 to change all in the same formula?

    I tried this:
    =INDIRECT("'allocation'!")&A10
    but it doesn't combine the two like I want it to.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481

    Re: Trouble joining a formula to be direct and indirect

    This may work for you
    =INDIRECT("Allocation!A"&9+ROW())

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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