I use lookup to get data from List Part.
When I use the below formula to display Description data from List Part. I find the below problem.
I could get result when I input string like "ssss" , But can not get anything when I typed number like "00010"
List Part: column PartNo is Single line of text
UseRyan Duguid provide
I remove the "0" before the number, this formula is working. in production environment, all PartNos do not start with 0
Been working on getting this to work for hours now. Thanks for providing the toLower solution
Retrieving data ...