How to use wildcards in mso excel xlookup: Difference between revisions

Revision as of 11:08, 17 January 2025

Excel 中结合 XLOOKUP 与通配符，将产生强大的生产力。以下讲讲在 XLOOKUP 中使用通配符的关键：

=XLOOKUP("*"&C3,$A$2:$A$51,$D$2:$D$51,"没找着",2,1)

诀窍在于用双引号把通配符引起来，用 & 把通配符与单元格连起来，第五个参数匹配模式选 2。

通配符：

Revision as of 11:08, 17 January 2025 view source Mwroot (talk \| contribs) Private_Access, Bureaucrats, Interface administrators, Administrators 7,227 edits No edit summary ← Older edit		Revision as of 11:08, 17 January 2025 view source Mwroot (talk \| contribs) Private_Access, Bureaucrats, Interface administrators, Administrators 7,227 edits No edit summary Newer edit →
Line 10:		Line 10:
	* ~ 用于转义		* ~ 用于转义

	[[Category: ~~MSO~~]]		[[Category: MicroSoft Office]]