Forum Discussion
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 ...
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.
- thank you so much iam gonna check it out and let you know if its work
