XLOOKUP Multiple Criteria in Multiple Columns and XLOOKUP Return Multiple Columns скачать в хорошем качестве

XLOOKUP Multiple Criteria in Multiple Columns and XLOOKUP Return Multiple Columns

📽️ In this Microsoft Excel video tutorial I demonstrate how to include multiple criteria in your XLOOKUP formula and how to return multiple columns in your XLOOKUP formula. If you need to return multiple matching records you can use the FILTER function. 👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺. https://www.paypal.com/donate/?hosted... Thank you! 👍👍 🕰️ Timestamps 00:00 Introduction 00:23 Multiple criteria columns - return first matching record 02:24 Multiple criteria columns - return all matching records and sum 03:32 Return multiple columns - return first matching record 05:44 Return multiple columns - return all matching records