+ Reply to Thread
Results 1 to 3 of 3

Index/Match wrong result

  1. #1
    Forum Contributor spinkung's Avatar
    Join Date
    10-27-2006
    Posts
    199

    Index/Match wrong result

    Hi

    i am having some trouble with the index/match lookup.

    I have a sheet with a linked table (to sql) with product info. i am trying to return the product description from that table to another sheet using product code.

    so...
    =INDEX(MyTable[Description],MATCH($F2,MyTable[ProductCode]))

    however, the result for code YWX0001 should return the description WATER. what i'm actually getting is the description of the last row in the table.

    i've also tried not referencing the table which also doesn't work

    so...
    =INDEX(MySheet!B:B,MATCH($F2,MySheet!A:A))


    weird!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,961

    Re: Index/Match wrong result

    Try:

    Formula: copy to clipboard
    Please Login or Register  to view this content.




    Regards, TMS
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,961

    Re: Index/Match wrong result

    Given this thread is marked solved, I take it that was the solution you were looking for?

    It is common courtesy in most forums to acknowledge the contribution and confirm that it worked for you.

+ 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. [SOLVED] Row and column match? (IF INDEX MATCH) What am I doing wrong.
    By Noop1887 in forum Excel General
    Replies: 2
    Last Post: 01-04-2015, 09:16 AM
  2. [SOLVED] Index/Match result should again search for zero result
    By ursanil in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-07-2014, 04:45 AM
  3. Wrong result displaying using IFERROR-INDEX-MATCH-ROW Formula
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-16-2013, 01:03 PM
  4. [SOLVED] Index and Match combination producing the wrong result
    By Authentik8 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-10-2012, 11:01 AM
  5. Index and Match-wrong value
    By Steved in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-13-2005, 07:06 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