怎么在 MSO Excel XLOOKUP 中使用通配符: Revision history

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

29 September 2025

  • curprev 09:5409:54, 29 September 2025Mwroot talk contribs 471 bytes +471 Created page with "Excel 中结合 XLOOKUP 与通配符,将产生强大的生产力。以下讲讲在 XLOOKUP 中使用通配符的关键: <code>=XLOOKUP(<font style="color: blue">"*"&C3</font>,$A$2:$A$51,$D$2:$D$51,"没找着",2,1)</code> 诀窍在于用双引号把通配符引起来,用 & 把通配符与单元格连起来,第五个参数匹配模式选 2。 <pre> 通配符: * 任意个数的任意字符 ? 单个字符 ~ 用于转义 </pre> Category: MicroSoft Office"