LinkBack URL
About LinkBacks
Is it possible to search for cells with more than 1 criteria.
Example, search for "this" and "that", would go to cell C4.
The criteria is that multiple values have to be found (AND, not OR).
Capture.PNG
Is it possible to search for cells with more than 1 criteria.
Example, search for "this" and "that", would go to cell C4.
The criteria is that multiple values have to be found (AND, not OR).
Capture.PNG
What do you actual mean with "would go to cell C4"?
I would offer 3 answers:
1- cell contents:
2- row number
=LOOKUP(2,1/ISNUMBER(SEARCH("this",$C$1:$C$4))/ISNUMBER(SEARCH("that",$C$1:$C$4)),$C$1:$C$4)
3- cell address:=LOOKUP(2,1/ISNUMBER(SEARCH("this",$C$1:$C$4))/ISNUMBER(SEARCH("that",$C$1:$C$4)),ROW($C$1:$C$4))
Attachment 842505=ADDRESS(LOOKUP(2,1/ISNUMBER(SEARCH("this",$C$1:$C$4))/ISNUMBER(SEARCH("that",$C$1:$C$4)),ROW($C$1:$C$4)),3)
Last edited by bebo021999; 09-12-2023 at 10:31 PM.
Quang PT
Thanks for responding.
I should have made it more clear but it would be to like the Find command, so it would go to the cell, and other cells after that.
Attachment 842518
May be:
In "Find & Replace":
Find what: this * that
Thanks very much bebo, did not think it would be as easy as this.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks