In this tutorial I gave the following features of the new XLOOKUP function with practical examples:
01:20 Xlookup Structure
03:35 Left Search
04:10 Error Handling
04:46 Approximate Filter
06:14 Horizontal Filter
06:44 Wildcard Search
07:32 Reverse Lookup
08:21 Two way search
Download your practical File: [ Ссылка ]
#Xlookup #HowtouseXlookup #XlookupExample
![](https://s2.save4k.ru/pic/3OesYTIfT-k/maxresdefault.jpg)