+ Reply to Thread
Results 1 to 5 of 5

How to incorporate IF and VLOOKUP formula to a Match Index Formula?

Hybrid View

  1. #1
    Registered User
    Join Date
    05-31-2010
    Location
    Manila
    MS-Off Ver
    Excel 2007
    Posts
    88

    How to incorporate IF and VLOOKUP formula to a Match Index Formula?

    I've a Match Index formula:

    FORMULA = INDEX(D:D,MATCH(1,INDEX((F2=E:E)*(D2=B:B),0),0))

    And I want to incorporate this condition

    If value of (vlookup(A2, D:F, 3, FALSE) is GREATER than zero(0) do FORMULA

    If EQUAL or LESS than zero(0) go to next row then if EQUAL or LESS than zero again go to next row

    If finally in the last row it gives GREATER than zero then do the FORMULA


    Is this possible?
    Last edited by geng; 06-06-2010 at 07:14 PM.

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: How to incorporate IF and VLOOKUP formula to a Match Index Formula?

    Hi geng
    anything is probable, but can you attach a small sample to help explain what you require?
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Registered User
    Join Date
    05-31-2010
    Location
    Manila
    MS-Off Ver
    Excel 2007
    Posts
    88

    Re: How to incorporate IF and VLOOKUP formula to a Match Index Formula?

    File attached

    Thanks for finding time to help! I appreciate it!
    Attached Files Attached Files

  4. #4
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: How to incorporate IF and VLOOKUP formula to a Match Index Formula?

    Hi geng,
    This should do the trick
    =SUMPRODUCT((G6=$B$4:$B$13)*(H6=$D$4:$D$13)*(E4:E13))

  5. #5
    Registered User
    Join Date
    05-31-2010
    Location
    Manila
    MS-Off Ver
    Excel 2007
    Posts
    88

    Re: How to incorporate IF and VLOOKUP formula to a Match Index Formula?

    Thanks Pike!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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