检查是否在一个单元格可能具有多个值的列中找到一个单元格值，然后返回第三个单元格值
问题描述：
我正在尝试检查A列中每个单元格中的值是否在D列中.D列中的某些单元格在单个单元格中具有多个值.如果在D列中找到A列的值，那么我希望公式返回B列中的值(匹配的A列旁边的值).
I am trying to check whether the value in each cell within Column A is in Column D. Some cells in Column D have multiple values within a single cell. If the value of Column A IS found in Column D then I want the formula to return what's in Column B (value next to Column A that matched).
答
尝试:
C2中的公式:
=IF(SUMPRODUCT(--(ISNUMBER(SEARCH(A2,$D$2:$D$5))))>0,B2,"")
向下拖动..