=index
(
[Book2]Sheet1!$a$1:$zz$999,
match
(
index
(
$a$1:$zz$999,
row
(),
1
),
[Book2]Sheet1!$a$1:$a$999,
0
),
match
(
index
(
$a$1:$zz$999,
1,
column
()
),
[Book2]Sheet1!$a$1:$zz$1,
0
)
)
手机转录，请认真核对后使用。两个空函数获取当前坐标。
--
修改:FuZu FROM 36.67.207.*
FROM 36.67.207.*