Forum Discussion
Leading spaces in cells
Hi! Very recently my workplace decided to start a shared Excel document (accessed via OneDrive). I am reasonably competent with regards to the basics of Excel but can't seem to resolve this issue...
Hi Petachu454 ,
Did you try using the https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929 formula instead of VLOOKUP, with match_mode as 1 or 2.
- Thanks, I was not aware of this. If I can't fix the issue with the spaces then I may recommend changing the formula.
