+ Reply to Thread
Results 1 to 2 of 2

Using INDEX & MATCH for date lookups?

  1. #1
    Forum Contributor
    Join Date
    02-15-2005
    Location
    Central UK
    MS-Off Ver
    Office 365
    Posts
    175

    Using INDEX & MATCH for date lookups?

    Hi,

    I'm trying to use INDEX & MATCH to find data below a date row. Normally don't have an issue but, I suspect, the date is causing the #N/A error.

    Attached a clipping of the file; using the MS date picker to select a date, A15 is the linked cell with the idea being that this cell (named "picker") will find the column with the matching date and return the "TOTAL REQUESTED".

    Sorry, this has been confusing me all morning - can anyone assist, please?

    Many thanks for taking the time to read this
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Using INDEX & MATCH for date lookups?

    A15 is empty
    You mean A16

    A16 is text
    The dates in row 2 are numbers

    When you perform the MATCH add zero to A16 to turn it into a number
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Index Match Match - 2 x Vertical Lookups - Not working as it should
    By seash in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-11-2016, 09:58 AM
  2. v lookups index and match if error help
    By zaid999 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-27-2016, 04:47 PM
  3. Index, Match and lookups explained (hopefully)
    By Michael in Nanchang in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-04-2015, 02:10 AM
  4. Sum multiple Index Match Lookups!
    By deadlyliquidxxx in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-13-2015, 08:55 AM
  5. Index and Match where one of the lookups needs to be nearest to
    By Alkaline198 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-21-2014, 04:35 PM
  6. INDEX and MATCH with range LOOKUPs?
    By neilbomb in forum Excel General
    Replies: 9
    Last Post: 06-22-2010, 07:33 PM
  7. Lookups Match Index??
    By myheadhurts in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-31-2008, 03:27 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