Forum Discussion
why does my xlookup return a space at the front of the results - excel Win 10
I have done Xlookup and the result has come through correctly EXCEPT it has randomly placed a space at the front of the result. So i was expecting "VT19756-01-50-" but i got " VT19756-01-50-" ...
Peta_Stolle77 I suspect that the return array ('Work Order List-20220707'!B:B) contains these texts with leading spaces. Clean-up that column or wrap the return array in TRIM.
=XLOOKUP($A75,'Work Order List-20220707'!$A:$A,TRIM('Work Order List-20220707'!B:B))