+ Reply to Thread
Results 1 to 6 of 6

Extracting data from another sheet

  1. #1
    Registered User
    Join Date
    08-25-2020
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Professional Plus 2019
    Posts
    3

    Extracting data from another sheet

    Hey fellas whatsup, i was trying achieve indexing or matching data from "data" sheet to "income" sheet here, would like to know if there is any function or formula i can use to achieve this.

    Based on Order ID in "income", i will need to collect back all Parent SKU Reference No., SKU Reference No., and Quantity from "data", and some of the order ID comes with multiple SKU or Quantity, this is where i am stuck, i mean i could achieve only if the ID itself have only 1 item sold, with =vlookup(b2,"data",4), I wont be able to get the other data. Could use a little bit of help here? Thanks guys!
    Attached Files Attached Files
    Last edited by xsjsx; 08-28-2020 at 05:26 AM. Reason: Prefix

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Re: Extracting data from another sheet

    In income sheet "N2"
    Formula: copy to clipboard
    Please Login or Register  to view this content.

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

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


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Registered User
    Join Date
    08-25-2020
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Professional Plus 2019
    Posts
    3

    Re: Extracting data from another sheet

    Thanks bud, this does work, but i do need to extract multiple data from"data", like, for order id B6 there are multiple items and quantity, i would like to return all of them, is that possible? Like after every result, press enter and copy the next SKU from the same Order ID.
    Last edited by AliGW; 08-28-2020 at 02:26 AM. Reason: Please don't quote unnecessarily!

  4. #4
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,776

    Re: Extracting data from another sheet

    income

    =IFERROR(TEXTJOIN("/",TRUE,IF(data!$A$2:$A$45=income!$B2,INDEX(data!$A$2:$N$45,,MATCH(income!N$1,data!$A$1:$N$1,0)),"")),"")

    control+shift+enter

    copy across and down
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    08-25-2020
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Professional Plus 2019
    Posts
    3

    Re: Extracting data from another sheet

    Wow you are awesome buddy, would you mind explaining how the function works so I could try working on another one next time? Thank you!

  6. #6
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,776

    Re: Extracting data from another sheet

    TEXTJOIN TUTORIAL


    https://www.youtube.com/user/ExcelIs...query=TEXTJOIN



    TEXTJOIN Works only for office 2019 and office 365
    Last edited by CARACALLA; 08-28-2020 at 03:35 AM.

+ 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] Extracting row data from sheet A to sheet B, based on cell value on sheet B.
    By JohnTrader in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-09-2019, 04:44 AM
  2. [SOLVED] Extracting data onto 1 sheet depending on the given sheet name
    By Eduards in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-01-2018, 06:08 PM
  3. Replies: 18
    Last Post: 07-08-2017, 11:53 PM
  4. Replies: 0
    Last Post: 08-03-2014, 03:32 AM
  5. Extracting Sum in one sheet with daily data being refreshed in another sheet.
    By Paritosh negi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-03-2013, 07:47 AM
  6. Replies: 5
    Last Post: 07-10-2013, 02:33 PM
  7. Extracting data from a row on one sheet into another sheet based on a unique cell
    By roshanvarghese in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-23-2013, 03:49 AM

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