我想問d好低能既問題
以前用開vlookup 就算係用緊table
想用個ID 搵個staff grade 係=vlookup(a2,Sheet1!A:G,7,0)
咁就會直接Read哂成行B staff id 搵到相應既result
宜家用xlookup 如果用滑鼠select row 一定出#n/a
因為佢好似一select 就將條formula 變左做table
=XLOOKUP(A2,bookABC.xlsx!
Table1[STAFF ID],bookABC.xlsx!
Table1[[#Headers],[GRADE]],0,0)
要我人手 將條read既table 轉返做指定值
$a$1:$a$184 同
$G$1:$G$184先出到result
有冇咩解決辦法
=XLOOKUP(A7,[bookABC.xlsx]Sheet1!
$A$1:$A$184,[bookABC.xlsx]Sheet1!
$G$1:$G$184,0,0)