#### shroeder

##### New Member
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”,” “)

‘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?

### Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Replies
1
Views
410
Replies
6
Views
694
Replies
6
Views
659
Replies
4
Views
359
Replies
0
Views
547

1,219,892
Messages
6,150,798
Members
450,985
Latest member
Andynair7

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back