TY  - BOOK
AU  - Ina Koys
PY  - 2023
CY  - , Deutschland
PB  - Computertrainerin.de
SN  - 9783910233126
TI  - Queries, VLookup, XLookup, & Co.
T2  - Find information and match values in Excel 365 and 2021
UR  - https://tolino.openpublishing.com/document/1355614
N2  - 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(). All are explained with examples and their specific benefits and downsides.
KW  - calculation, Excel, functions
LA  - Englisch
ER  -