Hi forum,
Just wanted to know if it's possible to index(match.... if the cell in reference contains one of many things (solved) but those "things" contain more than one option?
I'm referencing this help guide on exceljet: https://exceljet.net/formula/if-cell...of-many-things
But if the things contain multiple words would this still be possible to index the correct answer?
Cheers,
Julian
I Changed the Or to "," from E12:E15 Like indigo or neon to indigo, neon
and used below formula
=INDEX($F$12:$F$19,MATCH(1,INDEX((MMULT((COUNTIF($B12,"*"&TRIM(MID(SUBSTITUTE($E$12:$E$19&",^,^,^,^",",",REPT(" ",256)),{0,1,2,3}*256+1,256))&"*")),{1;1;1;1})>0)+0,0),0))
it works as much as 4 values (xx or xxx or xxxx or xxxxx)
see the attached file
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
how about using this one in nothing is changed in your original set up in C12 copy paste below then hold control and shift together and then hit enter to make it array formula and drag down
Formula:
Please Login or Register to view this content.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
Thank you both for your solutions, Very complex monster formulas but as long as they work i'm happy.
If you're happy to would you mind explaining how the formula works?
If not that's fine. I'm fine with a working result cheers guys!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks