My original thread got skewed somehow so I’m trying this again:
The following formula works fine:
IF(ISNUMBER(MATCH(E2,’Loop Library’!F$34:F$49,0)),”Fujimoto”,” “)
Because it’s only looking at three cells within the F34:F49 range that are the result of a filter.
But now when I re-filter those coumns in ‘Loop Library’ doc with new criteria, the corresponding formulas don’t see the filter, they just see the entire range. Here are two formulas that have that problem and I can’t figure out what’s different from the one that works:
IF(ISNUMBER(MATCH(E2,’Loop Library’!F$120:F$140,0)),”Chip Martin”,” “)
IF(ISNUMBER(MATCH(E2,’Loop Library’!F$6:F$103,0)),”Mike Bielenberg”,” “)
On the last thread, I was asked for more info about the filtering so here goes:
‘Loop Library’ is a worksheet with about 45 columns, three of which are relevant to this problem. The first two refer to a range of text values which are “<title of music piece>” and “<composer>”. The third column SUMS the number of times each piece of music was sold.
First, I filter all “0”s out of the SUM column so I only see pieces that have actually sold.
Second, I sort the “<composer>” column so I’m only seeing the works by one individual.
The formulas I’m using in the next worksheet are then supposed to only reference the visible range of cells in the “<title of music piece>” column.
Make sense?
The following formula works fine:
IF(ISNUMBER(MATCH(E2,’Loop Library’!F$34:F$49,0)),”Fujimoto”,” “)
Because it’s only looking at three cells within the F34:F49 range that are the result of a filter.
But now when I re-filter those coumns in ‘Loop Library’ doc with new criteria, the corresponding formulas don’t see the filter, they just see the entire range. Here are two formulas that have that problem and I can’t figure out what’s different from the one that works:
IF(ISNUMBER(MATCH(E2,’Loop Library’!F$120:F$140,0)),”Chip Martin”,” “)
IF(ISNUMBER(MATCH(E2,’Loop Library’!F$6:F$103,0)),”Mike Bielenberg”,” “)
On the last thread, I was asked for more info about the filtering so here goes:
‘Loop Library’ is a worksheet with about 45 columns, three of which are relevant to this problem. The first two refer to a range of text values which are “<title of music piece>” and “<composer>”. The third column SUMS the number of times each piece of music was sold.
First, I filter all “0”s out of the SUM column so I only see pieces that have actually sold.
Second, I sort the “<composer>” column so I’m only seeing the works by one individual.
The formulas I’m using in the next worksheet are then supposed to only reference the visible range of cells in the “<title of music piece>” column.
Make sense?