+ Reply to Thread
Results 1 to 6 of 6

Index Match Formula Not Pulling Correct Results

  1. 06-23-2016, 10:33 AM #1
    derivative2016
    derivative2016 is offline
    Registered User
    Join Date
    06-23-2016
    Location
    Houston, TX
    MS-Off Ver
    2010
    Posts
    1

    Index Match Formula Not Pulling Correct Results

    Hi,

    I was in the process of trying to pull data from a table using an Index, Match Formula, but for some reason, it is pulling from the incorrect results.

    Based on the attached spreadsheet, I am trying to pull how many reports are worked on by Company Code Per state. The list of states is in Column A, and the company codes are in row 11. So, I thought that my formula would easily pull when it set it up like this:

    Please Login or Register  to view this content.
    However, when I go to lookup say Delaware for company 8601 it is pulling up a different state and company code.

    Is there a quick fix to this?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-23-2016, 11:15 AM #2
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Index Match Formula Not Pulling Correct Results

    in the index / match formula you first need to declare the ROWS and second the COLUMNS

    That is where it went wrong.

    see my changed formula.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  3. 06-23-2016, 11:24 AM #3
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Index Match Formula Not Pulling Correct Results

    Try this...

    =VLOOKUP(M12,A11:J61,MATCH(N12,A11:J11,0),0)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  4. 06-23-2016, 11:36 AM #4
    derivative2016
    derivative2016 is offline
    Registered User
    Join Date
    06-23-2016
    Location
    Houston, TX
    MS-Off Ver
    2010
    Posts
    1

    Re: Index Match Formula Not Pulling Correct Results

    Wow that helped alot. Thanks very much with that

    Next question, why do I get a reference error whenever I try to reference anything below Hawaii? Table too large?
    Reply With QuoteRegister To Reply
  5. 06-23-2016, 12:54 PM #5
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Index Match Formula Not Pulling Correct Results

    @derivative2016

    It is always good to add to whom you are replying.

    The index / match formula will work, if you remove the trailing space in the file e.g. maine
    Reply With QuoteRegister To Reply
  6. 06-23-2016, 12:54 PM #6
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Index Match Formula Not Pulling Correct Results

    @derivative2016

    It is always good to add to whom you are replying.

    The index / match formula will work, if you remove the trailing space in the file e.g. maine
    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. [SOLVED] Index Match formula not returning correct results
    By JennOlsen in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-30-2015, 02:59 PM
  2. Index match formula is not pulling the correct data
    By thomashasler in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-20-2015, 03:14 PM
  3. INDIRECT(MATCH...) Formula pulling into correct place but not correct value
    By carrach in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 11-25-2014, 08:14 AM
  4. [SOLVED] pulling multiple results from one page and putting them on another (vlookup, index match?)
    By sugar824 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-28-2014, 05:41 PM
  5. [SOLVED] INDEX/MATCH - pulling monthly results for teams from separate sheets to a single result pg
    By f150guygk in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-21-2014, 03:43 PM
  6. Index Match not pulling in correct info
    By jeremiahbret in forum Excel General
    Replies: 1
    Last Post: 02-07-2012, 03:48 PM
  7. Index/Match formula not pulling through desired results
    By Climaxgp in forum Excel General
    Replies: 0
    Last Post: 08-02-2010, 08:14 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