looking for partial matches between two sheets

7 次查看（过去 30 天）
Islam
Islam 2017-5-17
评论： Guillaume 2017-5-18
I have two excel sheets as follow : sheet 1
A B
A 70811 spannar
B 3423 spanner
C 2334 looktide
Sheet 2
A
A spannar 123
B spanner 10 * 8 mm
C looktide
I want to know where in sheet1 I can find partial string matches with sheet2 and put the index match of sheet 2 in a new column beside the corresponding matched cell in sheet1
  2 个评论
Guillaume
Guillaume 2017-5-18
Missing from your question, and crucial, is your definition of a "partial string match"?
Looking at your example is it that strings in Sheet2 start with a string in Sheet 1. Or is it something more complex? (e.g., is annar a partial match for spannar 123?)

请先登录，再进行评论。

请先登录，再回答此问题。

回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by