+ Reply to Thread
Results 1 to 4 of 4

Help with Index and Match

  1. 04-01-2025, 12:48 PM #1
    greentea
    greentea is offline
    Registered User
    Join Date
    02-18-2010
    Location
    T.O.
    MS-Off Ver
    MS 365
    Posts
    61

    Help with Index and Match

    Hi friends,

    You guys were very helpful in creating a formula for me to match 2 cells in a table array. I have been using this formula for yrs! However, I recently noticed an error where the item is not picking up the correct result. Basically, I am trying to match the UPC in my Store tab with the By Product tab. The example file is attached. May I get your help to find the issue with the formula? (for your reference, this a planogram file and has over 100 columns which I deleted to simplify the example).

    Much appreciated!!!!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-01-2025, 01:38 PM #2
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,369

    Re: Help with Index and Match

    Hi greentea,

    I don't think your example gives the correct results. But watch
    https://www.youtube.com/watch?v=u1WalMZWWA8
    to see where I would go with your problem.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
  3. 04-01-2025, 03:01 PM #3
    greentea
    greentea is offline
    Registered User
    Join Date
    02-18-2010
    Location
    T.O.
    MS-Off Ver
    MS 365
    Posts
    61

    Re: Help with Index and Match

    Hi Marvin,

    The video was great and solved my problem! Also, Xlookup is so much easier to use than Index/Match.

    Thx so very much!!!
    Reply With QuoteRegister To Reply
  4. 04-01-2025, 03:21 PM #4
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,995

    Re: Help with Index and Match

    If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

    If a member helped you solve your problem, consider adding to their reputation by clicking $A addreputationiconsmall.jpg below their profile in any of their posts.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    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 function vs index match vba type mismatch
    By johnstylez in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-14-2022, 03:29 PM
  2. [SOLVED] INDEX+MATCH instead of VLOOKUP+MATCH, why is INDEX a better choice and how to re-write?
    By Renejorgensen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-23-2016, 10:54 AM
  3. [SOLVED] Index / Match - match 3 input values and return the results from the index
    By t83357 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-08-2016, 07:34 PM
  4. [SOLVED] Match-Index in stead of Index-Match lookup Array among Arrays
    By Numnum in forum Excel General
    Replies: 2
    Last Post: 10-15-2015, 02:08 PM
  5. Problems with multi-criteria Index/Match. LOOKUP works. Index/Match, SUMPRODUCT,ARRAY fail
    By sfike in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  6. Index, match, dynamic and connected without sorting helper column non-adjacent index match
    By Underling in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-08-2013, 10:29 PM
  7. [SOLVED] Concatenated INDEX MATCH formula that won't give error that can index match 2-4 strings
    By bkwins in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-02-2013, 01:31 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