+ Reply to Thread
Results 1 to 6 of 6

Lookup GL Code at another place and sum for that GL

  1. 12-15-2017, 08:30 AM #1
    vijayca
    vijayca is offline
    Registered User
    Join Date
    11-24-2013
    Location
    Mumbai
    MS-Off Ver
    Office 365
    Posts
    70

    Lookup GL Code at another place and sum for that GL

    Dear All,

    I have one GL Code name 41110000 and so on at one place. I have series of GL Code at another place with columns and values therein. I need formula where 41110000 GL Code is searched in the series of GL Codes and place sum values of columns corresponding to the same GL e.g. is given below.

    41110000 - sum = 24000
    41120000 - sum = 1700

    Series
    column A column B

    42033200 150000 20000
    41100000 8000 300
    41110000 20000 4000
    41120000 1500 200
    42020100 30 400

    Thanks in advance.
    Reply With QuoteRegister To Reply
  2. 12-15-2017, 08:36 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,597

    Re: Lookup GL Code at another place and sum for that GL

    Try this: ...............
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 12-15-2017, 08:38 AM #3
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,597

    Re: Lookup GL Code at another place and sum for that GL

    Try this:

    Excel 2016 (Windows) 32 bit
    [COLOR="rgb(255, 255, 255)"] [/COLOR]
    [COLOR="rgb(255, 255, 255)"]A[/COLOR]
    [COLOR="rgb(255, 255, 255)"]B[/COLOR]
    [COLOR="rgb(255, 255, 255)"]C[/COLOR]
    [COLOR="rgb(255, 255, 255)"]1[/COLOR]
    42033200
    150000
    20000
    [COLOR="rgb(255, 255, 255)"]2[/COLOR]
    41100000
    8000
    300
    [COLOR="rgb(255, 255, 255)"]3[/COLOR]
    41110000
    20000
    4000
    [COLOR="rgb(255, 255, 255)"]4[/COLOR]
    41120000
    1500
    200
    [COLOR="rgb(255, 255, 255)"]5[/COLOR]
    42020100
    30
    400
    Sheet: Sheet1

    Excel 2016 (Windows) 32 bit
    [COLOR="rgb(255, 255, 255)"] [/COLOR]
    [COLOR="rgb(255, 255, 255)"]F[/COLOR]
    [COLOR="rgb(255, 255, 255)"]1[/COLOR]
    =SUMPRODUCT([COLOR="rgb(255"]([COLOR=" 0"]A1:A5=E1[/COLOR])*([COLOR=" 0"]B1:C5[/COLOR])[/COLOR])
    Sheet: Sheet1
    Reply With QuoteRegister To Reply
  4. 12-15-2017, 08:40 AM #4
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,597

    Re: Lookup GL Code at another place and sum for that GL

    Sorry my Forum Tools add-in seems not to be working!

    With 41110000 in E1, this in F1:

    =SUMPRODUCT((A1:A5=E1)*(B1:C5))
    Reply With QuoteRegister To Reply
  5. 12-15-2017, 08:45 AM #5
    vijayca
    vijayca is offline
    Registered User
    Join Date
    11-24-2013
    Location
    Mumbai
    MS-Off Ver
    Office 365
    Posts
    70

    Re: Lookup GL Code at another place and sum for that GL

    Thanks a lot. Resolved the problem.
    Reply With QuoteRegister To Reply
  6. 12-15-2017, 08:46 AM #6
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,597

    Re: Lookup GL Code at another place and sum for that GL

    You're welcome!
    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. Code to place code into newly created sheets???
    By brucemc777 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-29-2014, 11:52 AM
  2. Code for copying a code into a specific place in an outlook template?
    By VoodooChild in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-21-2010, 10:08 AM
  3. lookup specific character place
    By Domenic in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 09-06-2005, 03:05 PM
  4. lookup specific character place
    By Budwho in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  5. lookup specific character place
    By Domenic in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 09-06-2005, 07:05 AM
  6. [SOLVED] lookup specific character place
    By Domenic in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 09-06-2005, 04:05 AM
  7. [SOLVED] lookup specific character place
    By Budwho in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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