+ Reply to Thread
Results 1 to 2 of 2

matching data and populating values

  1. #1
    Registered User
    Join Date
    04-04-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2007
    Posts
    25

    matching data and populating values

    PLease see attchemnt for explanation of formula needed.
    I have cloumn B that has some identical lot numbers, one for good production and one for bad scrap, I need a formula to find the matched lot numbers and will add the good into the same row as the bad scrap
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    08-06-2013
    Location
    Detroit, Michigan
    MS-Off Ver
    Excel 2013
    Posts
    671

    Re: matching data and populating values

    See if this works for you. You can either insert the formula directly into the columns wherever there is a 0 or just create a separate column and then copy and paste values.

    Excel example.xlsx

+ 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. Data to be converted in vertical form populating unique values
    By kapilkarap@gmail.com in forum Excel General
    Replies: 2
    Last Post: 04-16-2014, 08:10 AM
  2. Populating cells based on matching information
    By Jaspal in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-10-2013, 10:40 AM
  3. Replies: 7
    Last Post: 09-26-2012, 04:54 AM
  4. populating a table with unique ID and matching value
    By lkim in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-16-2011, 10:44 PM
  5. Populating data from one sheet to another by indexed values
    By Jrajan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2009, 04:38 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