+ Reply to Thread
Results 1 to 5 of 5

Help with finding a lookup value only if the dates in two columns match

  1. 12-02-2020, 06:01 AM #1
    rosscortb
    rosscortb is offline
    Registered User
    Join Date
    08-13-2009
    Location
    Glasgow
    MS-Off Ver
    Excel 2016,2016,365
    Posts
    92

    Help with finding a lookup value only if the dates in two columns match

    Hello,

    Not sure if it's lookup I need but I have one range that includes Master all staff id's, org unit, and date with 1st of month from 2018 - 2020

    In another range I have just the staff ids and the dates and I want to bring in the org unit but only for the values against matching dates.

    I've attached a small sample.

    Thanks

    Ross
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-02-2020, 06:12 AM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,411

    Re: Help with finding a lookup value only if the dates in two columns match

    One way:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Committed with Ctrl-Shift-Enter rather than just Enter
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 12-02-2020, 06:13 AM #3
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,411

    Re: Help with finding a lookup value only if the dates in two columns match

    Oops, with Error Handling:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Committed with Ctrl-Shift-Enter rather than just Enter
    Reply With QuoteRegister To Reply
  4. 12-02-2020, 07:07 AM #4
    rosscortb
    rosscortb is offline
    Registered User
    Join Date
    08-13-2009
    Location
    Glasgow
    MS-Off Ver
    Excel 2016,2016,365
    Posts
    92

    Re: Help with finding a lookup value only if the dates in two columns match

    Thanks for your help
    Reply With QuoteRegister To Reply
  5. 12-02-2020, 07:53 AM #5
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,411

    Re: Help with finding a lookup value only if the dates in two columns match

    You're welcome.
    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. Sorting Columns to match dates. Dates need to be on same rows
    By tdugas2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-02-2017, 05:42 PM
  2. Match or Vlookup: Finding the name value within a range of dates?
    By Tia_ in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-01-2016, 03:13 PM
  3. [SOLVED] Lookup function finding most recent dates
    By lorber123 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-12-2016, 09:46 AM
  4. [SOLVED] Lookup a serial number but overlook 0's in cell content when finding a match.
    By Hello23 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-14-2012, 02:55 PM
  5. VBA: Index/Match. 1 lookup value, 1 lookup array. copies cells from multple columns.
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-19-2011, 12:51 PM
  6. Finding a match in different columns
    By jonbolton in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-03-2009, 09:30 PM
  7. Finding a match in several columns
    By Keren in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-26-2005, 09:32 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1