Results 1 to 4 of 4

Newbie in VBA - Help to find value if two other conditions are met

This is a discussion on Newbie in VBA - Help to find value if two other conditions are met within the Excel Questions forums, part of the Question Forums category; Hi All, Well I am a complete newbie on VBA and am learning on the go at the moment. I ...

  1. #1
    New Member
    Join Date
    Mar 2016
    Posts
    2

    Default Newbie in VBA - Help to find value if two other conditions are met

    Hi All,

    Well I am a complete newbie on VBA and am learning on the go at the moment. I do have a "little" issue that I cannot figure out:

    So I have a workbook containing quite a lot of formulas already (these are working fine) but there's one last bit I cannot seem to resolve.

    The sheet is as follows (please note this is just partial data):

    Management:6
    Management:7
    ACCOUNT_NAME
    ORG 6 Update
    Corp Code
    Account Type
    Account Number
    12345678
    12345678- Account Name 1
    Account Name 1 -
    ABC123
    CORPORATE
    12345678
    87654321
    87654321 - Account Name 2
    Account Name 2
    -
    ABC123
    ACCOUNT
    87654321
    98765432 98765432 - Account Name 3 Account Name 3 - DEF456 CORPORATE 98765432
    23456789 23456789 - Account Name 4 Account Name 4 - DEF456 ACCOUNT 23456789


    Column A and G have the same value for now, column B is a concatenate of G and C. What should happen is following: Column A should reflect the account number of of the Corporate account type if the Corp Code is the same. I cannot figure out how to make this going (there are about 600 lines with multiple Corp Codes, Account Types and Account Numbers). Which is why I turn to you as you have been helpful to me creating this file so far (loving the forum!)

    Please help my poor brain with this problem

  2. #2
    Board Regular
    Join Date
    Apr 2010
    Posts
    8,941

    Default Re: Newbie in VBA - Help to find value if two other conditions are met

    Column A should reflect the account number of of the Corporate account type if the Corp Code is the same.

    what does this mean ? show us a desired output table

  3. #3
    New Member
    Join Date
    Mar 2016
    Posts
    2

    Default Re: Newbie in VBA - Help to find value if two other conditions are met

    Quote Originally Posted by oldbrewer View Post
    Column A should reflect the account number of of the Corporate account type if the Corp Code is the same.

    what does this mean ? show us a desired output table
    Hey Oldbrewer,

    Sorry if I wasn't clear

    So the desired output should be:

    Management:6 Management:7 ACCOUNT_NAME ORG 6 Update Corp Code Account Type Account Number
    12345678 12345678- Account Name 1 Account Name 1 - ABC123 CORPORATE 12345678
    12345678 87654321 - Account Name 2 Account Name 2 - ABC123 ACCOUNT 87654321
    98765432 98765432 - Account Name 3 Account Name 3 - DEF456 CORPORATE 98765432
    98765432 23456789 - Account Name 4 Account Name 4 - DEF456 ACCOUNT 23456789


















    I hope that the additional table helps making it clear! If not, I'll try to write it down again in other terms.

    Thanks again!

  4. #4
    Board Regular
    Join Date
    Apr 2010
    Posts
    8,941

    Default Re: Newbie in VBA - Help to find value if two other conditions are met

    say in words what information you seek and where you want it

    I cannot see where row 2 of your output comes from

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com