vlookup函数，入查询对象的数据表有多列如何查询，求教

G3=IFERROR(IFERROR(VLOOKUP($H3,IF({1,0},$B$3:$B$8,$A$3:$A$8),2,),VLOOKUP($H3,IF({1,0},$E$3:$E$8,$D$3:$D$8),2,)),"")
I3=IFERROR(IFERROR(VLOOKUP($H3,IF({1,0},$B$3:$B$8,$C$3:$C$8),2,),VLOOKUP($H3,IF({1,0},$E$3:$E$8,$F$3:$F$8),2,)),"")

@静心百善 我还是直接问大神吧， 随便什么函数都可以

Q1=IF($R3="","",INDIRECT(TEXT(MIN(IF($A$3:$O$5=$R3,ROW($A$3:$O$5)*100+COLUMN($A$3:$O$5)-1)),"R0C00"),))
S1=IF($R3="","",INDIRECT(TEXT(MIN(IF($A$3:$O$5=$R3,ROW($A$3:$O$5)*100+COLUMN($A$3:$O$5)+1)),"R0C00"),))
数组，按CTRL+SHIFT+ENTER

目瞪口呆

如果出现同一个学号不同的班级和名字的情况下Q3=TEXTJOIN(",",TRUE,IF(($B$3:$N$5=R3)*($B$3:$N$5<>""),$A$3:$M$5,""))
S3=TEXTJOIN(",",TRUE,IF(($B$3:$N$5=$R3)*($B$3:$N$5<>""),$C$3:$O$5,""))
数组，按下三键