求高手给Excel公式!

如楼主的图片所示,鉴于涉及条件太多,建议楼主先建个条件表.

假设条件表为SHEET1表,SHEET2表为楼主所贴表(如下图所示)

在SHEET2的D2输入:

=IF(MAX(N(ISNUMBER(FIND(Sheet1!$A$1:$A$13,A2))))=0,"",INDEX(Sheet1!$A$1:$A$13,MATCH(,0/ISNUMBER(FIND(S