课程: Excel Tips Weekly

免费学习该课程！

今天就开通帐号，23,100 门业界名师课程任您挑！

Using wildcards in the new XLOOKUP and XMATCH functions

Using wildcards in the new XLOOKUP and XMATCH functions - Microsoft Excel教程

课程: Excel Tips Weekly

开始一个月试用 购买团队方案

Using wildcards in the new XLOOKUP and XMATCH functions

“

- [Instructor] If you have Microsoft 365, 2 you have access to two new functions, XLOOKUP and XMATCH, 3 and these two functions are designed to be game changers. 4 XLOOKUP matches all the capabilities 5 and more of both VLOOKUP and HLOOKUP, 6 and XMATCH is designed to replace the MATCH function. 7 And admittedly, the examples we're seeing here 8 might seem a little obscure, 9 but wildcards themselves might be in that category too. 10 We're first of all looking for the employee in this list 11 that has the letter P in the license numbering. 12 Now, long story short, let's say the license characters 13 that are being used here have meaning 14 regarding employment status, location, 15 or years of service, something to do with the employee. 16 We're looking for the letter P here in the license column. 17 So XLOOKUP, anytime you type this = XL, just press tab. 18 It's the only function that begins with XL. 19 What are we…

内容