Jul 06 2022 11:06 PM
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-" with a space at the front any clues please as it is effecting my results and data
thank you
Result with space
this was my formula - =XLOOKUP($A75,'Work Order List-20220707'!$A:$A,'Work Order List-20220707'!B:B)
Jul 06 2022 11:15 PM
@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))
Jul 06 2022 11:19 PM
Feb 28 2024 05:43 AM
@Peta_Stolle77 Thanks Pete, I have been trying to fix that same error for months and never noticed that the formatting was wrong. post found almost TWO years after you posted it.