#### 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

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Replies
1
Views
407
Replies
6
Views
693
Replies
6
Views
651
Replies
4
Views
359
Replies
0
Views
546

1,219,828
Messages
6,150,473
Members
450,966
Latest member
Yali

### 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