Attached is the spreadsheet I am working on.  Very simple request.  base_data contains a product SKU, fineline code and a few others.  The worksheet product-heliumSKU uses a LET statement to take data from base_data and using the fineline code, use it to look up in another spreadsheet (fineline-heliumSKU) to obtain the helium SKU.  But alas, it seems to not find the helium SKU, yet the same XLOOKUP does return the helium SKU (see fineline-heliumSKU).  There has to be something wrong with the XLOOKUP in the LET statement, just stumped.

​Attached is the spreadsheet I am working on.  Very simple request.  base_data contains a product SKU, fineline code and a few others.  The worksheet product-heliumSKU uses a LET statement to take data from base_data and using the fineline code, use it to look up in another spreadsheet (fineline-heliumSKU) to obtain the helium SKU.  But alas, it seems to not find the helium SKU, yet the same XLOOKUP does return the helium SKU (see fineline-heliumSKU).  There has to be something wrong with the XLOOKUP in the LET statement, just stumped.  Read More

​