Search list of strings(cells) for particular string

You Could Use This Kind Of Statement

=IF(ISERROR(MATCH(look up string,Range,FALSE)),"Not Found","Found")


Thanks

Hi,

And if scaffold is only a part of the cell use

=IF(ISERROR(MATCH("*scaffold*",A1:A30,FALSE)),"NotFound","Found")

Select allOpen in new window

Regards

that would probably work for the whole sheet but i want it to look only at rows which contains selected value like month or year.
Look at my MAX code above. It would use the same range to look for that string
so that bit of my code -'[Tasklist Scotford 1702.xlsb]tasklist c300rev1702'!$A:$A=AA3108 - has  to be reused

Hi,
pls try someting like this

=IF(MAX(('[Tasklist Scotford 1702.xlsb]tasklist c300rev1702'!$A:$A=AA3108)*(IFERROR(FIND("scaffold",'[Tasklist Scotford 1702.xlsb]tasklist c300rev1702'!$P:$P),0))),"Found","NotFound")

Select allOpen in new window

as array formula

Regards

I tried that before and now again. (without MAX as well)
I'd use search as it's not case sensitive, but that doesnt work :/

=IF((('[Tasklist Scotford 1702.xlsb]tasklist c300rev1702'!$A:$A=AA3108)*(IFERROR(SEARCH("SCAFFOLD",'[Tasklist Scotford 1702.xlsb]tasklist c300rev1702'!$P:$P),0))),"Found","NotFound")

Select allOpen in new window

Hi,

Could you send a dummy example?

Regards

sheet1 contains a list of all cnt&group. I left one as an example. What Im doing is summing up norm. dur. and getting max number to another sheet for every cnt&group. That assumption should exclude all which at least one operation contains scaffolding, hence my question.

For now I sorted it as I created a list of all cnt&group which contains scaffolding and vlookup them with my current data but it would be good to automate it as i'd reuse it many times with different datasets
Book1.xlsx

good thinking with that Max ;) i should have realized that earlier! thanks