This formula works fine:
IF(ISNUMBER(MATCH(E2,'Loop Library'F$34:F$49,0)),"Fujimoto"," ")
Becuase 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 columns 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"," ")
This message was edited by Ian Mac on 2002-10-03 06:02
IF(ISNUMBER(MATCH(E2,'Loop Library'F$34:F$49,0)),"Fujimoto"," ")
Becuase 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 columns 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"," ")
This message was edited by Ian Mac on 2002-10-03 06:02