+ Reply to Thread
Results 1 to 3 of 3

Match one sheet with other Sheet

  1. 05-03-2017, 08:12 AM #1
    M. Shahbaz
    M. Shahbaz is offline
    Registered User
    Join Date
    01-14-2017
    Location
    Pakistan
    MS-Off Ver
    Ms Office 2016
    Posts
    35

    Match one sheet with other Sheet

    Hello every one,
    Dear i want to match one sheet (including some Raw Material's Data) with another's Sheet (which has Detail of Raw Material). I want to match one sheet with other sheet to find error in one sheet.
    Illustration:
    Let. I have full Record of All Raw Material in Sheet 1. I receive (Sheet 2) from Production Deptt. (in a Factory/Industry) and I want to match Sheet 2 with Sheet 1 to find error. But i have not any Formula which apply on Full Sheet and present me error. I am confused.


    Anyone help me.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-03-2017, 08:21 AM #2
    shukla.ankur281190
    shukla.ankur281190 is offline
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Match one sheet with other Sheet

    Well you want to match both sheet and if there is any match you want to highlight that one am i right??? If this then you must use MATCH function which can easily do this work.

    Try

    D5
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    But There is no match in your attached sheet that is why formula will give #N/A error if there would be any match it will give you Number.

    Hope this help you
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Reply With QuoteRegister To Reply
  3. 05-03-2017, 08:44 AM #3
    avk
    avk is offline
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: Match one sheet with other Sheet

    Look attach file.
    I have matching both sheet. In sheet1 column "D" & "E" extract data from sheet2
    In "F" column sheet1 & sheet2 data match with simple if formula.
    Column "G" add as helper (for sheet2)

    Same above process in sheet2
    Hope this is helpful.
    Attached Files Attached Files

    atul

    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Match Value in Sheet 1 with Sheet 2, copy entire row from sheet 1 to new sheet
    By lzyshaman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-01-2013, 07:48 AM
  2. look up on sheet 1 match data sheet 2 and fill in cell on first sheet
    By treborharris in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-28-2013, 01:01 PM
  3. [SOLVED] Lookup up from Sheet 1 in Sheet 2 and display additional value in Sheet 1 when match
    By azbridgie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-31-2013, 03:22 PM
  4. Macro to update database, Match Cell value from Sheet 1 in Sheet 2 then copy and paste
    By Zawoooo in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-03-2012, 03:10 AM
  5. match two columns in one sheet, copy to other sheet, match in additional sheets
    By michmart in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-25-2012, 03:38 PM
  6. Lookup email address in sheet 1, match with sheet 2 and copy row from sheet 2 to sheet 3
    By Guji in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-14-2012, 01:03 PM
  7. Match column from sheet 2 to sheet 1 and copy rows if match exists.
    By GravityInvert in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2008, 01:42 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1