Results 1 to 8 of 8

Index Match Errors

Threaded View

  1. #1
    Registered User
    Join Date
    06-21-2010
    Location
    Texas, San Antonio
    MS-Off Ver
    Excel 2007
    Posts
    57

    Index Match Errors

    Hello All,

    I am working on a excel sheet to help me with log ins and log outs. I have a sheet called Data where I dump all the log ins and outs. There are a multiple number of Reps with different days they work. What I want to do is have their log in; 15min break; 30 min lunch; and log out for the day to appear in certain cells. I am using the Index and Matching functions.

    For the Log In I use the following formula:
    =INDEX(Data!$D$1:$D$10000,MATCH($D$3,IF(Data!$G$1:$G$1000=$A$8,Data!$A$1:$A10000,0),0))

    It works great for the first Cell I paste it in but it gives me an #N/A Error for the rest of the cells.

    Also for the Log Out cells I wanted to use the Large Function in combination with the Index and Match. But I am not able to figure out the correct format. Any help would be greatly appreciated.

    Attached is my worksheet.

    Thanks
    Attached Files Attached Files
    Last edited by Coldsteel; 06-23-2010 at 03:45 PM.

Thread Information

Users Browsing this Thread

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

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