Excel - 匹配来自选项列表的子字符串 - INDEX，MATCH和FIND一起使用

``````Function GetRow(xCell As Range, xRange As Range)
i = 2
Do
If Cells(i, xRange.Column).Value = "" Then
Exit Do
ElseIf InStr(1, Cells(xCell.Row, xCell.Column).Value, Cells(i, xRange.Column).Value) > 0 Then
GetRow = Cells(i, xRange.Column + 1).Value
End If
i = i + 1
Loop
End Function
``````

``````=GetRow(\$A7; E:E)
``````
Question

**编辑：我认为这个问题的第一个版本，看起来像我只有一些电影和标题。 这些数据可能有助于：

``````Column A: 2,000 Total Video Titles (movie titles can appear more than once)
Column E: 50 Movie Titles
Column F: 50 Movie Descriptions
``````

``````A                                    B
Title                               Description
Spiderman Review and BTS
Best Dark Knight clips
Bloopers: Liar Liar
Interviews with The Departed cast
``````

.1996多个视频标题

``````    E                                 F
Title                             Description
Dark Knight                       Dark Knight Description
Spiderman                         Spider Man Description
The Departed                      The Departed
Liar Liar                         Liar Liar Description
``````

... 46更多的电影标题和描述

``````Row   A (video titles)          B (description)
48   Titanic romantic scenes
49   Dumb and Dumber bloopers
50   BTS Schindler's List
51   Story behind Get Out movie
52   Who are the X-Men?
``````

``````=if(isnumber(find("Spiderman",A2)),index(F2:F4,match("Spiderman",E2:E4,0)))
``````

``````{Index(\$F\$2:\$F\$4,match(TRUE,isnumber(find(\$E\$2:\$E\$4,A2)),0))}
``````