+ Reply to Thread
Results 1 to 5 of 5

Multiple match of cells based on 2 sheets

Hybrid View

Christopherdj Multiple match of cells based... 09-18-2014, 02:31 AM
XOR LX Re: Multiple match of cells... 09-18-2014, 02:42 AM
oeldere Re: Multiple match of cells... 09-18-2014, 02:50 AM
Christopherdj Re: Multiple match of cells... 09-18-2014, 03:16 AM
oeldere Re: Multiple match of cells... 09-18-2014, 03:37 AM
  1. 09-18-2014, 02:50 AM #1
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Multiple match of cells based on 2 sheets

    Match!f2=if(Iserror(match(B2&A2&C2&D2&E2,Data!$O$2:$O$70,0)>0),"no","yes")

    and drag down

    Data!O2=C2&F2&I2&J2&N2

    and drag down


    See the attached file (the green cells).

    Tip => use the same cellcontent for all the column on both sheets.

    Please reply.
    Attached Files Attached Files
    Last edited by oeldere; 09-18-2014 at 03:36 AM. Reason: changed iferror in iserror
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    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] Index and Match based on expiry dates in multiple sheets
    By Mr.Fatcat in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-10-2014, 04:58 AM
  2. [SOLVED] Match record number across sheets based on data from multiple columns
    By smithcw in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 08-12-2013, 02:25 PM
  3. Macro for multiFindandReplace btw sheets requiring multiple cells to match
    By jgutknecht in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-08-2013, 10:28 AM
  4. [SOLVED] Match multiple cells in seperate sheets and then insert cell
    By Jostler18 in forum Excel General
    Replies: 2
    Last Post: 05-01-2012, 04:59 PM
  5. Match cells from Multiple sheets and copy rows
    By Kilcup01 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-29-2011, 12:43 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1