=============================================================
a列包含b列,在c列中显示b列信息,
=INDEX(B:B,MIN(IF(ISNUMBER(FIND($B$2:$B$9,A6)),ROW($2:$9),100)))&""
a列包含b列,在c列中显示a列信息,
=LOOKUP(1,0/FIND(B5,A1:A9),A1:A9) 注释:B5要随着行增长而增加, A1:A9是不变的总数
=LOOKUP(1,0