Results 1 to 4 of 4

Need formula help to compare 2 data sheets and extract cell value

Threaded View

  1. #1
    Registered User
    Join Date
    09-13-2018
    Location
    canada
    MS-Off Ver
    office 2013
    Posts
    27

    Question Need formula help to compare 2 data sheets and extract cell value

    Hi all,

    Looking for formula help....

    I have 2 large data sheets. They contain overlapping data, and different data. I need to add a new column P in DataSheet A (DSA) which will return a value found in Data Sheet B (DSB)

    So I want the exact data combo found in DSA cells C2, D2 and L2 to then try and find a matching combination in DSB by looking in columns E, J and M.

    If the values found in DSA C2, D2 and L2 find matching combination in DSB columns E, J and M....THEN return value in DSB matching row column A to DSB column P2.

    I hope this makes sense. It's a bit hard to explain.

    I've added a demo excel to make it clearer hopefully. See attached.

    Thanks!
    Attached Files Attached Files
    Last edited by m_roussakis; 11-04-2020 at 03:21 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 30
    Last Post: 08-17-2015, 01:18 AM
  2. Replies: 7
    Last Post: 01-12-2015, 02:48 PM
  3. compare two excel sheets and extract common data
    By ravindraynk in forum Excel General
    Replies: 3
    Last Post: 07-25-2014, 10:18 AM
  4. Is it possible to compare two sheets and extract out the differences?
    By dwx in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2014, 11:51 AM
  5. compare and extract missing data from 2 sheets
    By BIGIFA in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-29-2011, 11:40 AM
  6. compare 2 sheets and extract only new rows
    By John in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-14-2006, 06:10 PM
  7. [SOLVED] Compare 2 Sheets and Extract Unique Info to a 3rd Sheet
    By kilo1990 in forum Excel General
    Replies: 7
    Last Post: 12-19-2005, 06:40 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