+ Reply to Thread
Results 1 to 2 of 2

Fill in the missing data to another table

  1. #1
    Forum Contributor
    Join Date
    12-29-2014
    Location
    Indonesia
    MS-Off Ver
    Office 2010, 2013
    Posts
    125

    Fill in the missing data to another table

    Hi all expert,

    Kindly help, I have a data (sample attached).

    I want to retrieve data from "table 1" to table 3. "table 2" is a table of changes to the data "account, CIF and Flag" in November 2018. example: CIF "ABC" there are changes to accounts and flags (the account changes to " 78910 "and the lost account is" 123, 456, 789 ". I want to fill in" table 3 "based on these changes where the lost accounts remain entered in" table 3 "and there is an" R "statement for the lost accounts from the data "table 1" in "table 3".

    Thank you ,
    Regard
    dolphino
    Attached Files Attached Files

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Fill in the missing data to another table

    Here is a way:
    in L: =IFERROR(INDEX(A$5:A$14,MATCH(0,INDEX(COUNTIF(L$4:L4,A$5:A$14),,),)),IFERROR(INDEX(G$5:G$8,MATCH(0,INDEX(COUNTIF(L$4:L4,G$5:G$8),,),)),""))
    in M and drag to N:=IFERROR(INDEX(B$5:B$14,MATCH($L5,$A$5:$A$14,0)),INDEX(H$5:H$8,MATCH($L5,$G$5:$G$8,0)))
    in O: =IFERROR(VLOOKUP(L5,$G$5:$J$8,4,0),"")
    in P:=IF(O5="","R","")

    Most likely, there is a way using a single formula, but is above my "pay grade" this morning.
    Click the * to say thanks.

+ 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] Fill missing data using vlookup.
    By 0Cool in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-12-2019, 12:02 PM
  2. [SOLVED] Calculate Missing Data and Fill
    By Student1990 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-10-2015, 04:29 PM
  3. Fill In Missing Months in Pivot Table
    By GregRus in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-09-2013, 09:27 PM
  4. Fill in missing data
    By crobledo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-04-2013, 08:30 AM
  5. fill missing data
    By bertusavius in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-10-2012, 01:53 PM
  6. Fill in missing data
    By Jbm444 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-16-2010, 11:42 AM
  7. Excel 2007 : to fill missing data in excel
    By sureshdoranga in forum Excel General
    Replies: 1
    Last Post: 12-01-2009, 07:15 PM

Tags for this Thread

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