Hello!
I attached an Excel file and a screenshot with the desired result.
Would you like to tell me where is my mistake?
Thank you!
Hello!
I attached an Excel file and a screenshot with the desired result.
Would you like to tell me where is my mistake?
Thank you!
Last edited by Zero-Sama; 06-15-2023 at 10:40 AM.
Maybe:
=FILTER($G$2:$G$4,ISNUMBER(SEARCH(F$2:F$4,A2)))
or (dyanmic array):
=BYROW(A2:A4,LAMBDA(x,FILTER(G2:G4,ISNUMBER(SEARCH(F2:F4,x)))))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thank your for your reply.
I want to keep the exact columns as I attached in thread.
Is there another way?
I have forgotten how to add " in array contants... so returning "test1" is a problem!!
Alternative:
=MAP(A2:A4,B2:B4,LAMBDA(x,y,CHOOSE(SUM({1,2,3}*ISNUMBER(SEARCH({"broad","phrase","exact"},x))),y,CHAR(34)&y&CHAR(34),"["&y&"]")))
this seems to get you the result you want...
=IFS(ISNUMBER(SEARCH("broad",A2)),B2,ISNUMBER(SEARCH("phrase",A2)),CHAR(34)&B2&CHAR(34),ISNUMBER(SEARCH("exact",A2)),"["&B2&"]")
you missed the quotes around broad
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Solved with the answer above.
Thank you both, I gave you all rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks