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"," ")
Paddy Wrote:
Care to give some more details re the range of you actual data, what values your data has, what you're filtering for etc. Would be good to have a worked example - data at the start, filter applied, expected outcome - or consider downloading the html maker addin from the link below this post & post up a snapshot of your data.
More info please...
Paddy
schroeder:
'Loop Library' is a worksheet comprised of about 45 columns, three of which are relevent to the problem at hand. In two of those columns are text values, "
Ian: I've had to delete the other post as it wasn't working correctly, Aladin Replied but I cound get that info.
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"," ")
Paddy Wrote:
Care to give some more details re the range of you actual data, what values your data has, what you're filtering for etc. Would be good to have a worked example - data at the start, filter applied, expected outcome - or consider downloading the html maker addin from the link below this post & post up a snapshot of your data.
More info please...
Paddy
schroeder:
'Loop Library' is a worksheet comprised of about 45 columns, three of which are relevent to the problem at hand. In two of those columns are text values, "
Ian: I've had to delete the other post as it wasn't working correctly, Aladin Replied but I cound get that info.
