问题:数据源中带合并单元格,需要进行多对一查找
函数解决:
=INDEX(C:C,MATCH(LOOKUP("座",E$1:E1)&LOOKUP("座",F$1:F1),LOOKUP(ROW($1:$12),ROW($1:$12)/(A$1:A$12>0),A$1:A$12)&B$1:B$12,))