Results 1 to 2 of 2

Excel 2007 : Indirect Function

Threaded View

  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

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