From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Use the XLOOKUP function to replace VLOOKUP

Use the XLOOKUP function to replace VLOOKUP - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Use the XLOOKUP function to replace VLOOKUP

- [Instructor] There's a new function in Excel 2 and it's going to have a dramatic impact on the way many 3 users work with Excel. 4 The third most commonly used function in Excel is VLOOKUP. 5 Now both VLOOKUP and HLOOKUP, which are similar, 6 are going to be replaced by XLOOKUP, 7 the new function. 8 For a while, only subscribers to Office 365 9 will have this function. 10 Now, in addition to including all the capabilities 11 of both VLOOKUP and H lookup, 12 there are additional attributes 13 and you see some of them listed in the yellow panel 14 on the screen here. 15 First of all, an exact match is going to be the default 16 for many Excel users. 17 They're trying to match up data on the basis 18 of ID type numbers or maybe names. 19 If it's inventory, maybe it's related 20 to part number, publication number. 21 I've got two lists on the screen here and want to 22 more or less pull together the list. 23 We don't…

Contents