+ 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
    50

    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: Office 365 in Windows environment
    Posts
    8,606

    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
    50

    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: Office 365 in Windows environment
    Posts
    8,606

    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)

Similar Threads

  1. [SOLVED] formula to consolidate tables
    By Kausch in forum Excel General
    Replies: 7
    Last Post: 11-02-2016, 05:24 AM
  2. consolidate 2 tables into one
    By dekel in forum Excel General
    Replies: 1
    Last Post: 07-09-2012, 04:32 AM
  3. Consolidate Multiple Data Tables
    By dangermouse1981 in forum Excel General
    Replies: 5
    Last Post: 07-15-2011, 12:04 PM
  4. Consolidate two pivot tables
    By ekat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-16-2010, 11:46 AM
  5. Add ‘country name’ column to worksheet from a list of country codes.
    By Ben Morton in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-02-2009, 09:24 AM
  6. Consolidate Pivot Tables
    By JS in forum Excel General
    Replies: 1
    Last Post: 06-30-2006, 02:50 PM
  7. [SOLVED] How do you consolidate tables contianing text?
    By samenvoegen van sheets in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-22-2006, 06:10 AM

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