+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Indirect Function

  1. #1
    Registered User
    Join Date
    04-03-2012
    Location
    Chicago
    MS-Off Ver
    Excel 2003
    Posts
    1

    Arrow Indirect Function

    So I have a question regarding INDIRECT Function.Is it possible to add two indirect functions within one cell. In the attachement, F1 and F3 are constant, while G through I change depending on values in A:C. So, in F1, there is 15, but in G2, there is 225 because "F1" + " A1" = 225. While that's easy with small amount of data, I have a large amount, and what I know is their "position". I would like to use Indirect function to do what is shown in K1:M1, because I know what I want to add which is A1, so with indirect function I get the result of 210, BUT, i would like to add the F1 part, so in G1 I have 225. The same pattern falls for H1 with 575 but here there is "B1"is added to "G1" instead of "F1" as 350+ 225 = 575. The same thing with the last column. Is it possible to do it without VBA or Macro as I would prefer to excel formula instead.

    Thanks

    PS. I hope that the values will change respectively if I put different amounts in range " A1:C1"
    Attached Files Attached Files

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Indirect Function

    Hi koaser,

    Welcome to the forum.

    I am not getting your query completely.. but I believe it should be simple drag with the similar arrangement of formulas you have ..
    just freeze the A1, B1, C1 and drag the formula down.. to freeze put the $ sign .. i.e., to freeze A1, convert it to $A$1 in formula. thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com

+ Reply to Thread

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