+ Reply to Thread
Results 1 to 4 of 4

Take a reference value from a cell and trace it with a Column.

  1. #1
    Registered User
    Join Date
    01-03-2022
    Location
    Australia
    MS-Off Ver
    2019
    Posts
    24

    Take a reference value from a cell and trace it with a Column.

    Hi,

    Let me explain my issue

    I have data in column C from cell C4 onwards. In Cell B4 i will put any value from the data of column C. In Cell D4, this value (which i put in Cell B4) should be traced from the column C and written in this cell D4.

    For Example,
    i put value 3 in cell B4.
    3 is in cell C7 in column C.
    Cell D4 should take value from B4 as reference and trace it in the Column C and write in its cell D4.
    After this, in cells D5, D6, D7 ......... next values after C7 i.e C8, C9, C10....... should be filled automatically.

    (sample file is attached for further clarification)
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    37,356

    Re: Take a reference value from a cell and trace it with a Column.

    Try this:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-03-2022
    Location
    Australia
    MS-Off Ver
    2019
    Posts
    24

    Re: Take a reference value from a cell and trace it with a Column.

    Hi @TMS,

    Now i used this for date and time instead of values. It is working for this also

    but

    there is a issue.
    from D19 to onwards 1/0/1900 0:00 this kind of date is coming. even it is not in the Column C. There should be blank cell after D18 instead of this date and time.
    (File is attached for further clarification)
    Attached Files Attached Files

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    37,356

    Re: Take a reference value from a cell and trace it with a Column.

    Long winded, but try:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    If you have Excel 365, it could be shortened to
    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ 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. Replies: 1
    Last Post: 08-14-2015, 02:49 AM
  2. Replies: 1
    Last Post: 02-11-2015, 01:56 PM
  3. Trace a column to check for matches.
    By Ayra in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-29-2013, 05:26 PM
  4. [SOLVED] Protect sheet but allow trace precedents / trace dependents?
    By abchak1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-16-2013, 10:32 AM
  5. [SOLVED] help with macro to trace precedents in a column
    By burnettec in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-28-2013, 04:40 PM
  6. Trace dependent does not work, trace precedent does
    By marnie in forum Excel General
    Replies: 0
    Last Post: 05-23-2007, 12:50 PM
  7. how do i trace back my sort command on a column ?????
    By rp in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-01-2005, 09:15 AM

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