Closed Thread
Results 1 to 2 of 2

Index/Match Formula Translate to VBA

  1. #1
    Registered User
    Join Date
    05-18-2020
    Location
    Richmond, Virginia
    MS-Off Ver
    MS Excel
    Posts
    3

    Index/Match Formula Translate to VBA

    Hello,

    I am trying to figure out how to set up an IF statement and and Index/Match formula in VBA. I've tried and failed. Could someone help me figure out to set this up in VBA?

    ESTDATA is a tab in my workbook, all other cell references are within the same worksheet.

    Thanks so much!

    =IFERROR(IF(MATCH(G8,C8,0),-SUMIF(ESTDATA!J:J,$A8,ESTDATA!$AB:$AB)*-E8),0)

    =(INDEX(ESTDATA!$P:$P,MATCH($A15,IF(ESTDATA!$P:$P<>"",IF(ESTDATA!$P:$P<>"No Vendor",IF(ESTDATA!$P:$P<>"BUDGT",IF(ESTDATA!$P:$P<>"00000",ESTDATA!$J:$J),IF(ESTDATA!$P:$P<>"GENER",,0)))))))

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,344

    Re: Index/Match Formula Translate to VBA

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread

Closed 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 not cycling through entire index. Formula not updating when values change...
    By nordxnortheast in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-07-2020, 10:44 AM
  2. Replies: 1
    Last Post: 08-17-2019, 01:11 PM
  3. Translate Index/Match function with multiple variables into VBA code
    By censley14 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-26-2018, 06:48 PM
  4. Replies: 0
    Last Post: 02-19-2018, 08:54 AM
  5. How can i translate an Index/Match formula into VBA code?
    By hzarry in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-06-2015, 12:42 PM
  6. Replies: 3
    Last Post: 05-02-2013, 01:31 AM
  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