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.
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.
I'll be honest, it's quite late here, and I don't think I'll get those formulas. I'll take a look at them tomorrow to try and figure out how it works. Nevertheless, I can confirm that these work perfectly fine!
I can't help but ask: In the last file you sent, the curly braces (formula as an array? I have a VERY basic understanding of this, as I'd never heard about it, and had some 10 minutes of search on the topic) don't seem to do anything. So the formula "as is" and as an array seems to work the same. Could you explain the purpose of this?
Last, but not least, I can't thank you enough for this! I spent... I don't know how many, but many hours trying to figure this out.
Thank you, thank you, thank you!!!