Use lookup can not output data filter on Number

+2

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.

Formula Builder

lookup("Part","PartNo",PartNo,"Description")

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

+2

UseRyan Duguid‌ provide

lookup("Part","PartNo",toLower(PartNo),"Description")

I remove the "0" before the number, this formula is working. in production environment, all PartNos do not start with 0

+3

Been working on getting this to work for hours now. Thanks for providing the toLower solution

Sign up