+ Reply to Thread
Results 1 to 5 of 5

Fill Data from one table in other table

  1. #1
    Registered User
    Join Date
    08-10-2015
    Location
    Iowa
    MS-Off Ver
    Mac 2016
    Posts
    2

    Fill Data from one table in other table

    Hi,
    I attached a workbook.
    The workbook contains two tables.
    Each Table has data missing that can be found in the other table.

    Is there a way to get the missing data from each of the tables?

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,430

    Re: Fill Data from one table in other table

    Somehow I get the impression that you just want this done, but in the event that you do want to know how to do so in the future:
    • Populate E2 with the following formula and copy down and across to column F:
    Please Login or Register  to view this content.
    • Copy the formula itself to G2 and rearrange the second IF() statement so that the formula reads:
    Please Login or Register  to view this content.
    • Again copy down and across.
    • Select copy the data in the four new columns.
    • Select A2 and paste special values.
    • Here is the file with the above formulas and copy/paste applied.

    Copy of Question.xlsx
    Let me know if you have any questions.

  3. #3
    Registered User
    Join Date
    08-10-2015
    Location
    Iowa
    MS-Off Ver
    Mac 2016
    Posts
    2

    Re: Fill Data from one table in other table

    Thanks,
    I actually am glad you gave the formula as it may be useful in the future.

    I am relatively new to excel, especially if/And statements.

    Once again,
    Thanks.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,430

    Re: Fill Data from one table in other table

    You're welcome and thanks for the feedback. If you have not already done so, please take a moment and mark the thread as 'Solved' using the thread tools link above your first post. Hope that you have a good day.

  5. #5
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Fill Data from one table in other table

    I combined columns A and B to form one column then combined columns C and D to form another column
    Enter in F2 and fill down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Enter in G2 and fill down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Array enter (Ctrl + Shift + Enter) in I2 and fill down. This will combine the contents of columns F and G and remove duplicates at the same time:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    If you want to separate the values back into 2 columns. Enter this in J2 and fill down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Enter this in K2 and fill down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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. VBA: Fill out column with lookup table refering to table headers
    By AnnaGT in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-02-2015, 03:03 AM
  2. Replies: 1
    Last Post: 11-25-2014, 08:35 PM
  3. Help with VBA code to find bottom row in pivot table and fill table cell borders
    By Eric111 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2014, 07:15 PM
  4. Look up values in from one table and fill in a column on another table with corresponding
    By Courtland Clarkson in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-06-2013, 12:18 PM
  5. Fill planner table relying on data from another table winery planner
    By pleb in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-10-2013, 04:54 AM
  6. [SOLVED] fill reference table based on data available in master Table
    By jsimha in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-31-2013, 12:19 PM
  7. Fill a table using data from another table
    By treva26 in forum Excel General
    Replies: 1
    Last Post: 09-06-2007, 09:29 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1