Results 1 to 4 of 4

Match dates in two colums, then insert value next to matched date

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-10-2014
    Location
    UK
    MS-Off Ver
    2010
    Posts
    272

    Match dates in two colums, then insert value next to matched date

    I have two columns of dates, these are in a random order in C2. In E2 the dates are in sequence.

    The dates in C2 may or may not exist in E2, and there maybe blank cells interspersed in Column C.

    I've been trying to achieve this with index/match but just can't get it to work.

    If the date is found in Col C & E, place a value from A1 next to the date in Col E.

    Any help appreciated.

    Thanks

    Edit : The dates in column C may occur more than once, but only once in Col E
    Last edited by sipa; 12-06-2014 at 02:18 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 06-18-2013, 07:45 AM
  2. Find a match btw two workbooks and insert row below the matched value in wBook2
    By Excelrookie_1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2013, 10:51 PM
  3. [SOLVED] Match Data, Insert data when matched, do again with different criteria
    By applelover in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-13-2012, 05:24 PM
  4. [SOLVED] Match staff name and date then import data from matched row (Example attached)
    By Hyflex in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-26-2012, 10:33 AM
  5. [SOLVED] Cross Match Date & Name then import data for matched row.
    By Hyflex in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-24-2012, 11:07 AM

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