We are doing a match(index) formula and it doesn't work when there is a number with a leading zero

This is the current formula and it works for every other type, normal numerical numbers and alpha numeric numbers. When it is just numeric with a leading zero it will not return the data.

Does anyone know why this isn't working and what we can do to make it work?

=IFERROR(INDEX({Shipping Log - Date}, MATCH(IFERROR(VALUE([ld_lot]@row), [ld_lot]@row), {Shipping Log - Lot Number}, 0), 0), "No Shipping Log Entry")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!