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
------------------------