Forum Discussion
Search for (an exact?) match in C, that is contained in the text on B.
In my first reply i didn't realize that in column [Cut down strings] there are dashes in the end in the first 2 rows: "This is a string -" and "This is another string -". However i'd suggest to use a table without dashes like this: "This is a string" and "This is another string". In the attached file i've changed the formula for column [Result 2] to return the results "1" and "16" and "X - 2".
I don't know why it doesn't work in the other file. I'd delete both tables of the other file and start over.
Does the attached suggestion help you? The formulas in the file have to be entered with ctrl+shift+ enter if one doesn't work with Office 365 or Excel for the web or Excel 2021.
Wow, that was fast!
I didn't even think of attaching a file haha
Thank you so much!!!
One small kink I got when I got the formula into the table, is this:
The highlighted rows show "-1", "-16" and "X - 2". Only the last one is correct, but the first two should be "1" and "16". I tried this change, but I think I broke the logic:
Maybe you have an idea on how to fix it?
Again, thank you so much!!
This really helps a lot.