+ Reply to Thread
Results 1 to 4 of 4

How to retrieve data from cell when target cell raw/line needs to be combined.

  1. #1
    Registered User
    Join Date
    02-07-2019
    Location
    New York
    MS-Off Ver
    Office 365
    Posts
    21

    How to retrieve data from cell when target cell raw/line needs to be combined.

    Hi guys,
    I need to retrieve the data from a cell, for example the below formula will retrieve the data in cell A2 in Data Base sheet.
    ='Data Base'!A2

    How can I retrieve the data when the row number is created by a separate Match formula?
    The Match formula retrieves the row number, I need to use it to complete the ='Data Base'!C{row number from Match formula needed here}
    Please see attached image.

    thanks
    Attached Images Attached Images
    Last edited by Zivhodiva; 05-18-2019 at 02:55 PM.

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,546

    Re: How to retrieve data from cell when target cell raw/line needs to be combined.

    Maybe this in C2?
    =INDEX('Data Base'!C:C,B2)

    BSB

  3. #3
    Registered User
    Join Date
    02-07-2019
    Location
    New York
    MS-Off Ver
    Office 365
    Posts
    21

    Re: How to retrieve data from cell when target cell raw/line needs to be combined.

    Works! ))

    thanks so much BSB

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,546

    Re: How to retrieve data from cell when target cell raw/line needs to be combined.

    Happy to help.

    BSB

+ 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. Highlight/Retrieve data in a cell based on entries in a different cell
    By SaraFet in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2018, 12:12 PM
  2. Timestamp beneath target cell when target cell's value changes based on calculation.
    By arwebb0264 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-15-2016, 06:31 PM
  3. Self Ajusting cell , moving to provide target to meet end of year target
    By andycuk7 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-15-2016, 11:22 AM
  4. Replies: 5
    Last Post: 01-22-2013, 11:38 AM
  5. How to input data from a clicked on Hyperlinked Cell into the target cell
    By SoCalSQ in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-05-2012, 11:18 AM
  6. Selected Cell data in Target Cell
    By MAGICofSeth in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-26-2009, 03:49 PM
  7. combined scatter plot and line data
    By bmayers in forum Excel General
    Replies: 2
    Last Post: 06-25-2006, 01:15 PM

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