Please help, Jedi council!

shroeder

New Member
Joined
Aug 20, 2002
Messages
17
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?
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Forum statistics

Threads
1,144,278
Messages
5,723,464
Members
422,498
Latest member
KAT112014

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top