如何横向搜索数据?

文章正文

发布时间:2025-01-11 13:31

=xLOOKUP(B2&"",HSTACK(TOCOL(席位!$A$2:$A$4&席位!$C$2:$J$4),TOCOL(席位!$B$2:$B$4&席位!$C$1:$J$1)),2,0)