+ Reply to Thread
Results 1 to 5 of 5

pull data based on cell value in the same sheet

  1. #1
    Forum Contributor
    Join Date
    07-14-2021
    Location
    LY
    MS-Off Ver
    2019
    Posts
    271

    pull data based on cell value in the same sheet

    hello
    I have data and it's increasble what I want it. it searches data based on cell value J2 . it should match with COL C and bring the data in COL M with considering some items are duplicated based on COL C . it should merge and summing
    Attached Files Attached Files

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: pull data based on cell value in the same sheet

    Data Range
    L
    M
    3
    brand
    food1
    4
    batch
    bt-1000
    5
    type
    tr
    6
    import
    122
    7
    export
    102
    8
    balance
    20

    Data Range
    L
    M
    3
    brand
    =INDEX(B:B,MATCH(J2,C:C,0))
    4
    batch
    =J2
    5
    type
    =VLOOKUP(J2,C:D,2,0)
    6
    import
    =SUMIF(C:C,J2,E:E)
    7
    export
    =M6-SUMIF(C:C,J2,F:F)
    8
    balance
    =M6-M7


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: pull data based on cell value in the same sheet

    Vba...
    By the way...your export and balance values are swapped around...
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  4. #4
    Forum Contributor
    Join Date
    07-14-2021
    Location
    LY
    MS-Off Ver
    2019
    Posts
    271

    Re: pull data based on cell value in the same sheet

    sintek
    By the way...your export and balance values are swapped around...
    thanks for correcting my mistakes .
    yes I prefer by vba . there is no better than vba .
    thank you so much

  5. #5
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: pull data based on cell value in the same sheet

    Pleasure...tx for rep +

+ 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. Formula (Index?) to pull data from one sheet to another based on cell data
    By kikijean in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-04-2021, 10:00 PM
  2. [SOLVED] Pull data from one sheet to another based on cell value
    By kv.singh in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-17-2020, 02:56 PM
  3. need vba to pull data from another sheet based on cell input
    By anuwers in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-29-2020, 02:03 PM
  4. Replies: 0
    Last Post: 03-30-2016, 09:08 PM
  5. Pull data from multiple sheets based on cell in Main sheet
    By cpyter in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-29-2014, 01:19 PM
  6. Replies: 19
    Last Post: 05-13-2013, 01:08 PM
  7. Replies: 3
    Last Post: 01-27-2013, 07:23 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