LOOKUP and Ignore Extra Spaces | Combine XLOOKUP, TRIM & CLEAN in a Custom LAMBDA Function скачать в хорошем качестве

LOOKUP and Ignore Extra Spaces | Combine XLOOKUP, TRIM & CLEAN in a Custom LAMBDA 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! 👍👍 In this video I demonstrate how to use Excel's LAMBDA function to create a custom function that automatically ignores extra spaces when you perform a lookup. The TRIM and CLEAN functions are used in Excel to get rid of spaces either in your lookup value, your table array or your lookup array. Creating a custom LAMBDA function that automatically includes TRIM and CLEAN functionality will save a lot of time in the long run. Table of Contents: 00:00 - Introduction 01:20 - Perform an XLOOKUP 02:13 - Use TRIM to get rid of spaces 02:36 - Use CLEAN to get rid of spaces 03:02 - Use LAMBDA to create a custom function 06:44 - Use your custom LAMBDA function in another workbook ------------------------