+ Reply to Thread
Results 1 to 3 of 3

Know which cell to get value from

  1. #1
    Registered User
    Join Date
    Aarhus, Denmark
    MS-Off Ver

    Know which cell to get value from

    Hi I dont know if this is possible, but hope it is.

    Suppose i have the following table, i want the value in D10, to go the steps back in column C that the value in B2 states.
    In the shown case, the value is 4, so D10 goes 4 steps back in C, and gets the value 5. If i change the value in B2 to lets say 3, D10 would automatically give the value 6 instead, as this is 3 steps back in column c.

    Hope it makes sense

    Screen Shot 2015-12-10 at 16.34.39.png

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    Kanpur, India
    MS-Off Ver
    Office 365 ProPlus

    Re: Know which cell to get value from

    Welcome to the forum.

    Try this...

    In D10
    Please Login or Register  to view this content.

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16

    Re: Know which cell to get value from

    Hi, welcome to the forum

    Hopfully sktneer's suggestion has answered your question?

    For future reference, Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
    Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

    Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] When one cell equals value of another cell, then third cell displays text of fourth cell?
    By spookymyo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-12-2021, 02:12 PM
  2. Replies: 0
    Last Post: 03-20-2014, 10:57 AM
  3. [SOLVED] Macro Delete Contents in 23rd corresponding cell if the cell in range is a non-blank cell
    By murtaza.khan in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-04-2014, 01:11 AM
  4. If Cell A is equal to Cell B replace the data from Cell A with Cell C. How can I do this.
    By tristanhathaway in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-01-2014, 08:05 PM
  5. [SOLVED] How to create/run "cell A equals Cell B put Cell C info in Cell D
    By abmb161 in forum Excel General
    Replies: 7
    Last Post: 02-05-2014, 02:20 AM
  6. Replies: 1
    Last Post: 11-06-2013, 02:56 AM
  7. copy a cell multiple times depending on cell value starting on a specific cell
    By weritadiojomiel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-17-2013, 05:25 AM
  8. Replies: 1
    Last Post: 11-03-2012, 09:05 PM


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