+ Reply to Thread
Results 1 to 2 of 2

VBA Code to run INDEX MATCH combo in a TABLE

  1. #1
    Registered User
    Join Date
    10-09-2017
    Location
    Stavanger, Norway
    MS-Off Ver
    O365
    Posts
    78

    VBA Code to run INDEX MATCH combo in a TABLE

    I have a WORKBOOK with multiple SHEETS (in excess of 13 000 rows of data in each), The data in both SHEETS is inserted in a TABLE. I need a total of 13 different INDEX MATCH combos to combine data from each. This process slows down Excel dramatically rendering it almost unusable.
    The solution is to NAME the functions, run a code at WORKBOOK OPEN that performs the INDEX/MATCH functions, and PASTE the result as VALUES.

    The most complex INDEX MATCH function I am using is..
    =INDEX(NPDLithostrat[lsuName];MATCH(1;([@WellBore]=NPDLithostrat[wlbName])*(NPDLithostrat[lsuLevel]="GROUP")*([@[MD RKB]]>NPDLithostrat[lsuTopDepth])*([@[MD RKB]]<=NPDLithostrat[lsuBottomDepth]);0))

    When I try and Create this function is the NAME MANAGER, the "refers to" returns an error highlighting the "@" symbol... probably because it wont accept the @ symbol.

    I have little experience of writing VBA code for FORMULAS. Can any one help me with this "challenge"

    Simon

  2. #2
    Valued Forum Contributor
    Join Date
    09-30-2018
    Location
    Vlaams Brabant Belgium
    MS-Off Ver
    365
    Posts
    456

    Re: VBA Code to run INDEX MATCH combo in a TABLE

    Hi,

    you have office 365 I suggest you take a look at power pivot and make the formula in DAX its way faster
    Please be as complete as possible in your asking so it may save use all the time to rework the solution because you didn't give all the requirements. If you have a layout in mind please work it out first so we can adapt our solution to it. Thanks.
    If you have been helped, maybe you could click the *

+ 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] combo - sumif/index/match
    By moe32 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-17-2019, 01:37 PM
  2. [SOLVED] INDEX/MATCH combo with using nth result
    By Hearny in forum Excel General
    Replies: 10
    Last Post: 03-16-2018, 06:13 PM
  3. [SOLVED] Index Match Combo
    By SimonCampbell in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-19-2017, 06:25 AM
  4. Index, Match, If / And, Combo Box used in Conjunction??
    By childs71 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-07-2015, 08:35 AM
  5. [SOLVED] Index Match into code when name is selected from combo box.
    By nancytaylor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-28-2013, 03:57 PM
  6. Three Way Lookup Using Index Match Combo
    By nathanhamilton82 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-07-2012, 03:39 PM
  7. Lookup, Index, Match ... Not sure which combo will do it?
    By nikko4239 in forum Excel General
    Replies: 4
    Last Post: 06-08-2010, 06:32 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