質問する

James Evans's profile - activity

2019-01-15 15:35:11 +0200 バッジを受け取った  体系学者
2014-06-26 16:27:00 +0200 バッジを受け取った  人気の質問 (source)
2014-06-26 16:27:00 +0200 バッジを受け取った  有名な質問 (source)
2014-06-26 16:27:00 +0200 バッジを受け取った  卓越した質問 (source)
2014-01-12 19:21:23 +0200 バッジを受け取った  自己学習者 (source)
2014-01-12 19:21:23 +0200 バッジを受け取った  教師 (source)
2014-01-12 04:43:26 +0200 質問に回答する [Calc] Partial word searches, using cell references and regular expressions.

add: &"." instead of just .

Code requested was:

=MATCH(C2&".*", $b$2:$b$10000, 0)
2014-01-12 04:27:53 +0200 バッジを受け取った  編集者 (source)
2014-01-12 04:08:56 +0200 質問をする [Calc] Partial word searches, using cell references and regular expressions.

So I know I can use regular expressions to do something like :

=MATCH("hello.*", $b$2:$b$10000, 0)

But if i have two collums, b and c, and I want to find if the word in the cell at c is included, whole or partially, in list b. For example:

B            C
Helpxo       Help
12345-075    12345
123          123

So I want to be able to put a formula in D that gives positive matches for all of those examples. I tried:

=MATCH(C2.*, $b$2:$b$10000, 0)

But, it didn't work.

EDIT: Found it here's the code:

=MATCH(C2&".*", $b$2:$b$10000, 0)