+ Reply to Thread
Results 1 to 2 of 2

Match/Index Calcuation Speed

  1. #1
    Registered User
    Join Date
    08-14-2008
    Location
    United States
    Posts
    25

    Match/Index Calcuation Speed

    Hello,

    I'm doing a match index for about 200+ different values.
    My formula looks like this:
    =INDEX('Part Info'!E:E,MATCH(1,('Part Info'!A:A=A1)*('Part Info'!B:B=B1),0))

    It takes a really long time to calculate all 200+ values.
    Is there anyway to speed this up?

    Please let me know!

    Thanks in advanced

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676
    Do you need to use whole columns like A:A and E:E? Perhaps restrict your ranges if you have less data

+ 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. Processing speed
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-07-2008, 02:21 PM
  2. How to increase speed in Excel processing
    By ROLLET in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2008, 04:11 AM
  3. speed up formula
    By khalid79m in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-28-2007, 02:00 PM
  4. Is there a way to speed this up?
    By twodwarfminimum in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-21-2007, 10:00 AM
  5. Trim File Size & Speed Up Excel?
    By DCSwearingen in forum Excel General
    Replies: 3
    Last Post: 11-16-2006, 05:29 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