Forum Discussion
l_Bilal_l
Sep 16, 2022Copper Contributor
Fields mismatch problem
Hi everyone wish you all good day I have the following problem I have Column A and Column C. - I know that in column C there are some materials that are identical to column A, but the names of ...
mtarler
Sep 16, 2022Silver Contributor
l_Bilal_l In the attached I have some 'near matching' Lambda functions. Basically I have one called:
NearMatches2( [value], [range], [min_letters], [direction])
so you pass it the value to search for, the range to search over, the minimum number of letters that need to match and direction can be 'Dual'/0, 'Forward'/1, or 'Backward'/-1 to search for partial matches based on the first X characters, the last X characters or check in both directions.
Maybe it will help.
- l_Bilal_lSep 17, 2022Copper Contributorthank you so much iam gonna check it out and let you know if its work