Difference between revisions of "怎样使用 MSO Excel XLOOKUP 函数"
Jump to navigation
Jump to search
← Older edit
Newer edit →
怎样使用 MSO Excel XLOOKUP 函数
(view source)
Revision as of 10:24, 21 August 2024
97 bytes added
,
21 August
no edit summary
Revision as of 10:21, 21 August 2024
(
view source
)
Mwroot
(
talk
|
contribs
)
← Older edit
Revision as of 10:24, 21 August 2024
(
view source
)
Mwroot
(
talk
|
contribs
)
Newer edit →
|}
在 Office 365 Excel 中,两个表格的数据如下。那应该怎么用 XLOOKUP 来弄呢?我们在 E2 里输入公式 <code> =XLOOKUP(A2,$L$2:$L$12,$M$2:$Q$12,"无此房号",0,1) </code>
,再回车即可得到 E2 至 I2
的值,再在单元格右下角往下拖动,
即可
得到其他值
。
[[File:XLOOKUP用法示例.png]]
Mwroot
Private_Access,
Bureaucrats
,
Interface administrators
,
Administrators
3,135
edits
Navigation menu
Personal tools
Log in
Namespaces
Page
Discussion
Variants
Views
Read
View source
View history
More
Search
Navigation
Main page
Random page
Tools
Special pages
Printable version