+ Reply to Thread
Results 1 to 4 of 4

Consolidate 3 Tables By Country

  1. #1
    Registered User
    Join Date
    12-08-2014
    Location
    South Dakota
    MS-Off Ver
    MS Office 365
    Posts
    49

    Consolidate 3 Tables By Country

    Hello all, hope you are staying safe and well,

    I have 3 tables all sorted by country, 1 table provides a dollar value, 1 table provides a number value, the last table provides a text narrative.

    I want to combine the three tables so it's country, dollar, number, text narrative.

    I'm attaching the data and what I'm looking for.

    Thanks so much in advance!
    Attached Files Attached Files

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    6,941

    Re: Consolidate 3 Tables By Country

    Data in second table is really inconsistent with the other two. first some countries are with (*) designation in first and third, without it in second
    VIET NAM vs. Vietnam
    Belgium vs Belgium-Luxembourg
    CROATIA (local name: Hrvatska) vs Croatia
    CRUISE VESSELS
    not to mention present only in table 2
    ARUBA
    BAHAMAS
    etc.

    Before homogenisation, there is no good way to make common table.
    If you can accebt missing some data you can start with =G2 in J2, simple
    =VLOOKUP(J2,A:B,2,0) in K2
    =IFERROR(VLOOKUP(SUBSTITUTE(J2,"(*)",""),D:E,2,0),0) in L2
    and =H2 in M2
    and copy down
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    12-08-2014
    Location
    South Dakota
    MS-Off Ver
    MS Office 365
    Posts
    49

    Re: Consolidate 3 Tables By Country

    This is close enough, thanks a million!

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    6,941

    Re: Consolidate 3 Tables By Country

    Glad to hear so, and thanks for reputation point and for marking thread SOLVED

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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