Results 1 to 4 of 4

Index Match Problem for multiple matches

Threaded View

Coldsteel Index Match Problem for... 09-13-2010, 09:07 AM
NBVC Re: Index Match Problem 09-13-2010, 09:19 AM
Richard Buttrey Re: Index Match Problem 09-13-2010, 09:21 AM
Coldsteel Re: Index Match Problem for... 09-13-2010, 10:29 AM
  1. #1
    Registered User
    Join Date
    06-21-2010
    Location
    Texas, San Antonio
    MS-Off Ver
    Excel 2007
    Posts
    57

    Index Match Problem for multiple matches

    Hello all,

    I have a excel sheet which allows me to select a rep in cell G2 and then I use Index/Match formulas to help me find all the data on that person. The problem i am having is that my index formulas are not working correctly. Either it gives me N/A# or wrong info.
    Here is my formula:

    =INDEX(Sheet1!A$2:A25,MATCH($G$2,Sheet1!$B$2:$B$250,0))


    I have attached my excel sheet as well.


    Thanks
    Attached Files Attached Files
    Last edited by Coldsteel; 09-13-2010 at 10:31 AM.

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