+ Reply to Thread
Results 1 to 2 of 2

Index/match or Vlookup to exclude data

  1. #1
    Registered User
    Join Date
    06-25-2011
    Location
    Boston
    MS-Off Ver
    Excel 2007
    Posts
    25

    Index/match or Vlookup to exclude data

    Hi everyone

    I have this table below, I used an index/match array formula for two columns of criteria, to display the totals for all the week 5's and display the totals in another sheet. But now I need to a formula to display any of the weeks total's that are greater than zero and excluding week 5. Is there a way to make wither a vlookup or an index/match function to exclude criteria/data???

    PERSON WEEK TOTAL
    MRS.TW 5 20
    MR.ONE 1 0
    MR.ONE 2 0
    MR.ONE 5 40
    MR.ONE 26 0
    MR.THRE 3 5
    MR.THRE 5 40
    MR.R 4 3
    MR.R 5 10
    MR.R 1 3
    MRS.FOU 4 30
    MRS.FOU 3 5
    MRS.FOU 5 40
    MR.SEVE 5 40
    MRS.TEN 5 40
    MRS.TEN 1 15
    MRS.TEN 20 2
    MR.ELEV 3 4
    MR.ELEV 1 0
    MR.ELEV 5 25
    MR.ELEV 4 7



    Thank You

    MZing81
    Last edited by MZing81; 04-21-2012 at 01:13 PM.

  2. #2
    Registered User
    Join Date
    06-25-2011
    Location
    Boston
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Index/match or Vlookup to exclude data

    The idea is not to use a pivot table seeing that this already is one. I want a formula for it. It's going to be part of larger project with a generator. I have already put together an index and match formula with this table to pull data based on criteria from two columns. But the formula will me avoid using a autofilter in a macro which thru experience has been problematic for me.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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