如何将单元格与列匹配并基于此返回值？

Question

+-------+---+--------------+----+
| A     | B | C            | D  |
+-------+---+--------------+----+
| Mark  |   | Hasan Shahed | 50 |
+-------+---+--------------+----+
| Hasan |   | Saif Alam    | 60 |
+-------+---+--------------+----+
| Kabir |   | Mark Islam   | 70 |
+-------+---+--------------+----+
| Alam  |   | Ena Sanu     | 80 |
+-------+---+--------------+----+
| Sanu  |   | Joes Kabir   | 100|
+-------+---+--------------+----+

我想将 A1 与 C 列匹配。如果匹配，则设置值 B1=D 列中的对应值

预期结果如下：

+-------+-----+
| A     | B   |
+-------+-----+
| Mark  | 70  |
+-------+-----+
| Hasan | 50  |
+-------+-----+
| Kabir | 100 |
+-------+-----+
| Alam  | 60  |
+-------+-----+
| Sanu  | 80  |
+-------+-----+

我如何在 Excel 上执行此操作？

Answer 1

您可以使用VLOOKUP通配符来实现这一点：

=VLOOKUP("*"&A1&"*",C$1:D$5,2,0)

*可以匹配任意内容。