Let's review several examples and see which function works better for lookups. Is it XLOOKUP or the FILTER function? You may not have thought about FILTER, but it does some things better than XLOOKUP.
XLOOKUP - [ Ссылка ]
FILTER - [ Ссылка ]
Spreadsheet used - [ Ссылка ]
Timestamps:
0:00 Overview
0:43 Simple lookup
3:57 Return multiple columns
5:44 Inexact matches
10:05 Using a not found message
12:47 Reverse search order
15:07 Return all matches
16:47 Matching multiple criteria
Learn more from Prolific Oaktree:
🌳 Next Video - Spreadsheets 3.0 - [ Ссылка ]
🌳 Related Playlist - Google Apps | Full Tutorials - [ Ссылка ]
#googlesheets #spreadsheet #xlookup
![](https://i.ytimg.com/vi/zFo9H0Uw4i8/maxresdefault.jpg)