Results 1 to 7 of 7

Index Match returning values when none should be returned

Threaded View

  1. #1
    Registered User
    Join Date
    03-21-2014
    Location
    Johannesburg
    MS-Off Ver
    Excel 2010
    Posts
    7

    Index Match returning values when none should be returned

    Hi guys, I realise my subject line is a little confusing.
    My issue is I have 2 spreadsheets Receive & Recon.
    On the Receive sheet I record goods received in a simple table form per date.
    On the Recon sheet I have all the items I receive brought across from the item column per day.
    I use the Index Match formula to identify the quantity & cost of the item received and populate the day relevant day columns.
    The formula I use is: =INDEX(Receive!$E$3:$K$1000,MATCH(H$1,Receive!$E$3:$E$1000,MATCH($E3,Receive!$H$3:$H$1000,0)),6)
    The issue is that the formula continues to populate the cells even when there is no data available for the relevant date. It continues to use the last value available.
    I think what is happening is that in the first Match command (matching the dates) is not exact "0" When the formula is evaluated it returns a "1" or greater than value
    I have attached a copy of my sheets & would appreciate any help in getting this resolved.
    Thanks in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 03-01-2014, 11:56 PM
  2. Duplicate values returned using Index Match Lookup with Small()
    By jacob@thepenpoint in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-18-2013, 10:48 AM
  3. Index and Match not returning values
    By -Spax- in forum Excel General
    Replies: 11
    Last Post: 12-06-2011, 11:29 AM
  4. Index and Match function returning same values
    By Climaxgp in forum Excel General
    Replies: 4
    Last Post: 12-15-2009, 05:59 AM
  5. Returning MULTIPLE values with Index and Match
    By Fly in forum Excel General
    Replies: 1
    Last Post: 06-01-2006, 12:55 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