+ Reply to Thread
Results 1 to 3 of 3

INDEX Match With VBA

  1. #1
    Registered User
    Join Date
    10-01-2019
    Location
    Miami, Florida
    MS-Off Ver
    2016
    Posts
    73

    INDEX Match With VBA

    I am trying to escalate values based on an index from another worksheet. The other worksheet is called "X". Currently, my formula is as follows:

    Please Login or Register  to view this content.
    This code is part of a loop and works perfectly. It is linking the cells I want to the cells in the "Money In" workbook. My issue is figuring out how to multiply each of these values by a factor that is indexed from worksheet "X". The key in worksheet "X" is in the range B10:B20 and the factors I want to pull in and multiply by are in E10:E20. How would I go about doing this?

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: INDEX Match With VBA

    Hello smw10c,

    Seems to me, it would be simpler just to use formulas and forget VBA in this case.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    10-01-2019
    Location
    Miami, Florida
    MS-Off Ver
    2016
    Posts
    73

    Re: INDEX Match With VBA

    There is a specific reason I need to do it without manually entering in formulas, however, I figured it out.

+ 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] 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
  2. [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
  3. [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
  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: 6
    Last Post: 04-30-2014, 02:42 AM
  6. Replies: 6
    Last Post: 11-08-2013, 10:29 PM
  7. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1