Google Sheets XLookup Function

preview_player
Показать описание
This video covers the XLOOKUP Function in Google Sheets. This function is an improved version of the VLookup Function. It has additional capabilities over the VLookup such as:
1. The ability to pull back multiple columns.
2. Perform searches from right to left.
3. It allows custom error messages for values not found.
4. It allows users to find the last match.
5. It allows wildcard search options.

Learn more about Google Sheets Functions with this Book at Amazon.

Buy the complete Google Workspace User Guide at Amazon:

DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links

#GoogleSheetsXlookupFunction
#GoogleSheetsXlookup
#GoogleSheetsNewFunctions2022
Рекомендации по теме