Koys Ina. Queries, VLookup, XLookup & Co.: Find information and match values in Excel 365 and 2021

Independently published, 2023. — (Short & Spicy, vol. 11).поиск информации и сопоставление значений в Excel 365 и 2021
Excel can take large data sets. But getting hold of required data can be tricky. Here, different possibilities are explained: The filter and the VLOOKUP() which are often heard of, but not really mastered. But there are more options like the Advanced filter, IF(), Database functions and the new, cutting-edge ones like SWITCH() and the brand new, very convenient XLOOKUP().Excel worksheets often contain huge datasets. All important information is somewhere within them; finding it is a whole different thing. And once it’s found it may need some processing. Therefore, we’ll be covering known, less known, and brand-new ways of filtering, evaluation with database functions and a number of ways to query, applying custom conditions. To get it done, there’s a set of different possibilities, traditional ones and also the cutting-edge ones, so far confined to the users of Excel 365.What we’re going to look at
The standard filter
Advanced Filter
The FILTER()-Function
Database functions
Insertions using conditions
Calculations using conditions
VLOOKUP()
XLOOKUP()
More