sai k
asked on
Hi, issue with searching a set of strings in excel
In excel, I have data in column A and I need to search for set of strings in column A. I should get findings in column B.
Ex:
column A column B result
Apple no findings
Pen found pen
pen in the Book found pen,book
Cat no findings
House found house
Deer no findings
elephant house found elephant,house
I need to search pen,book,house,elephant in column A and in corresponding column I have to get found pen,found house.....
I can do this with if condition but the data that I have is huge and so taking lot of time for execution. can this be done with some inbuilt excel functions like search({"pen","house","... },A:A).... .????
Ex:
column A column B result
Apple no findings
Pen found pen
pen in the Book found pen,book
Cat no findings
House found house
Deer no findings
elephant house found elephant,house
I need to search pen,book,house,elephant in column A and in corresponding column I have to get found pen,found house.....
I can do this with if condition but the data that I have is huge and so taking lot of time for execution. can this be done with some inbuilt excel functions like search({"pen","house","...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I have recommended this question be closed as follows:
Accept: Rgonzo1971 (https:#a41858061)
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
frankhelk
Experts-Exchange Cleanup Volunteer