Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Help! I need HELP! How to reference a cell with a formula

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Say a column cell contains B5 contains a value

    In C6 I want to put in a formula the goes to cell A(B5 + 4).

    For example, if B5 contained the value 7, I want C6 to get the value in A(7+4) or A11.

    Is there any easy way to do this? EASY = without a Macro.

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try the following formula:

    =INDIRECT("A" & B5+4)
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,006
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default


    =INDIRECT("A"&4+B5)

    and,

    how about:

    =OFFSET($A$1,4+B5-1,0,1,1)

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    SUMIF('Master Illustration'!$D$12:$D$55,">0")

    ok, that seems to work, but say the cell reference I want to change is $d$55 - I want it to be D(11 plus the value in B5).

    Currently b5 is 44 so D(11 plus 44) is D55.

    I have a huge sheet that I have to manually make this change currently.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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