+ Reply to Thread
Results 1 to 7 of 7

Struggling with a formula for dynamic value pickup...PLEASE HELP

  1. 05-10-2021, 04:38 AM #1
    iLoveMaggi
    iLoveMaggi is offline
    Registered User
    Join Date
    12-29-2020
    Location
    Delhi, India
    MS-Off Ver
    2016
    Posts
    33

    Unhappy Struggling with a formula for dynamic value pickup...PLEASE HELP

    i want specific data of one sheet to transfer to another sheet automatically on the basis of a primary column

    So I want the data of `all transactions`(sheet n my work book) to be transferred to the `Table 3` on the basis of `RST no.`(common column among the tables)

    I also have a formula for this (i.e- For cell c4=IFERROR(IF(b4="","",INDEX('ALL TRANSACTIONS'!B$5:B$1001,AGGREGATE(15,6,ROW('ALL TRANSACTIONS'!B$5:B$1001)-ROW('ALL TRANSACTIONS'!#REF!)+1/('ALL TRANSACTIONS'!$F$5:$F$1001=B4),ROWS('ALL TRANSACTIONS'!#REF!:'ALL TRANSACTIONS'!#REF!)))),""))
    but I don’t know why its not working............

    And if you are going to suggest a new formula or make changes in the formula can you make it so the formula stays dynamic i mean so that i can use it not only for `date` but also for `vehicle no.` `net weight`(columns of my table)...etc by doing minor changes in the formula..

    for more info check the attached workbook...

    Thanks a Lot in Advance
    Attached Files Attached Files
    Last edited by iLoveMaggi; 05-10-2021 at 07:45 AM.
    Reply With QuoteRegister To Reply
  2. 05-10-2021, 05:44 AM #2
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,447

    Re: Help with a formula

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    Reply With QuoteRegister To Reply
  3. 05-10-2021, 06:19 AM #3
    iLoveMaggi
    iLoveMaggi is offline
    Registered User
    Join Date
    12-29-2020
    Location
    Delhi, India
    MS-Off Ver
    2016
    Posts
    33

    Re: Help with a formula

    changed it...
    Reply With QuoteRegister To Reply
  4. 05-10-2021, 10:46 AM #4
    iLoveMaggi
    iLoveMaggi is offline
    Registered User
    Join Date
    12-29-2020
    Location
    Delhi, India
    MS-Off Ver
    2016
    Posts
    33

    Re: Help with a formula

    the formula on the question have those #ref parts because i removed some data.... to make the sample workbook...
    sorry about that
    Reply With QuoteRegister To Reply
  5. 05-10-2021, 02:03 PM #5
    CARACALLA
    CARACALLA is offline
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,781

    Re: Struggling with a formula for dynamic value pickup...PLEASE HELP

    Sheet2

    C4=IF(Sheet2!$B4<>"",IFERROR(INDEX(INDEX('ALL TRANSACTIONS'!$A$5:N$1001,,MATCH(Sheet2!C$3,'ALL TRANSACTIONS'!$A$4:$M$4,0)),MATCH(Sheet2!$B4,'ALL TRANSACTIONS'!$F$5:$F$1001,0)),""),"")

    Copy across and down
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 05-10-2021, 10:57 PM #6
    iLoveMaggi
    iLoveMaggi is offline
    Registered User
    Join Date
    12-29-2020
    Location
    Delhi, India
    MS-Off Ver
    2016
    Posts
    33

    Red face Re: Struggling with a formula for dynamic value pickup...PLEASE HELP

    Thanks a Lot CARACALLA...
    I mean really thankyou very much...
    Actually i think you were the one who also provided the formula in the question...
    it was on a different thread
    i almost lost the hope of finding an answer to that question...
    Once again thankyou for your efforts may god bless you


    Reply With QuoteRegister To Reply
  7. 05-10-2021, 11:01 PM #7
    iLoveMaggi
    iLoveMaggi is offline
    Registered User
    Join Date
    12-29-2020
    Location
    Delhi, India
    MS-Off Ver
    2016
    Posts
    33

    Re: Struggling with a formula for dynamic value pickup...PLEASE HELP

    and can i once again bother you can you tall me...
    how can i get better at excel... i couldn't understand the formula you just provided
    so can you recommend me any paid course/youtube channel/book so i can improve in future
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to copy formula in another cell but with a different reference in the formula
    By sHAMBLES88 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-24-2020, 07:27 AM
  2. IF formula not working because cell has a formula in it (IF and LEFT FORMULA)
    By Beh162 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-10-2019, 09:34 AM
  3. find formula for (formula)+(*1.5 if colum A has certain word) if not use original formula
    By amac4556 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-16-2018, 06:50 AM
  4. [SOLVED] Formula SUM(A+B) - Copy formula to SUM(D+E), SKIP C. Automatic formula
    By hens91 in forum Excel General
    Replies: 8
    Last Post: 09-22-2017, 05:41 AM
  5. Excel formula bar to display the result of the formula , not the formula?
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2016, 07:15 PM
  6. Copy Value String text of Formula become Formula but the formula not automatically active
    By Yovan Wisnu in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  7. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1