+ Reply to Thread
Results 1 to 3 of 3

INDEX MATCH MATCH will not auto populate and takes LONG

  1. #1
    Registered User
    Join Date
    04-19-2015
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    5

    Question INDEX MATCH MATCH will not auto populate and takes LONG

    I am working on a Pricing Grid our restaurant group for all active offerings. To do this I am comparing an ID number to a DBF file to return a LEVEL ID. That ID along with the store name are used to get the GROUP NAME, LEVEL NAME, and LEVEL PRICE. I am using INDEX MATCH MATCH to do this. However when I enter the name of the store and the LEVEL ID the other three cells are not populating. When I drag the formulas down it will recalculate but it take forever to process.

    Did I use right the formulas incorrectly? Should I not be using tables until I collect all the data and then format as a table?


    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,416

    Re: INDEX MATCH MATCH will not auto populate and takes LONG

    That is probably because of the full ranges you've used:

    =IFERROR(INDEX(PRICE_LVL!E:E,MATCH([@[PRICE GROUP]],IF(PRICE_LVL!B:B=[@[LEVEL ID]],LIQ_PRICE[ref_name]),0)),"")

    Limit these to just what is necessary.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Contributor
    Join Date
    03-22-2017
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    230

    Re: INDEX MATCH MATCH will not auto populate and takes LONG

    simply mean

    replace PRICE_LVL!E:E with LIQ_PRICE[level_id] or PRICE_LVL!$E$1:$E$1000

    replace PRICE_LVL!B:B with LIQ_PRICE[level_id] or PRICE_LVL!$B$1:$B$1000
    Hope you can learn every time you visit here.

    If you still confuse on how it work, kindly ask or go to
    i) Formula - Formula (Ribbon) > Formula Auditing (Section) > Evaluate Formula > Evaluate; or
    ii) VBA/Code - Click F8 to see how it work step by step.

    It it take care of your question, Please:
    Mark tread as [Solved] [Thread Tools->Mark thread as Solved]
    ;and
    Click *Add Reputation to thank anyone solved your question.

+ 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. INDEX MATCH returns #N/A - Formula too long?
    By maym in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 07-27-2017, 06:33 AM
  2. Replies: 5
    Last Post: 02-18-2017, 11:21 AM
  3. Faster option than VLOOKUP? INDEX/MATCH is taking twice as long...
    By mrbusto71 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-12-2015, 09:44 PM
  4. INDEX MATCH MATCH/OFFSET MATCH MATCH with named ranges
    By Andrew-Mark in forum Excel General
    Replies: 3
    Last Post: 02-27-2015, 10:56 PM
  5. Replies: 2
    Last Post: 11-03-2014, 02:29 PM
  6. INDEX/MATCH formula taking too long
    By Rob Ardill in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-09-2014, 11:01 PM
  7. Replies: 5
    Last Post: 02-29-2012, 08:51 PM

Tags for this Thread

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