+ Reply to Thread
Results 1 to 3 of 3

INDEX MATCH MATCH will not auto populate and takes LONG

Hybrid View

  1. 04-25-2018, 11:13 AM #1
    njm0059
    njm0059 is offline
    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
    Reply With QuoteRegister To Reply
  2. 04-25-2018, 12:34 PM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,703

    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. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 04-26-2018, 04:32 AM #3
    BoredWorker
    BoredWorker is offline
    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 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. 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. Index Match to match values separated by comma from a list, with each match reporting
    By jparve3283 in forum Excel General
    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. INDEX with multiple MATCH's used with IF's taking a really long time to calculate
    By suziep1980 in forum Excel Formulas & Functions
    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. Index/Match/Match. Formula looking veritcal and horizontal headings to find a match
    By rain4u in forum Excel Programming / VBA / Macros
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1