Hello,
I am trying to find the value with the highest number of matching digits but that is smaller than my expression. I am trying with the Index function but can't make it work.
These are my reference :
Code Id.
44010000 176
44011000 3
44012100 2
44012200 4
44013100 5
44013900 6
44030000 177
44032000 194
Now I have the following number for which I want to find the id :
44013010
The result I want to get is id 176 because there is a match on the first 5 digits for 44013100 but 44013100 is higher 44013010, so I refuse that match and need to match on 4 digits on 44010000.
Can anyone help?
Thanks,
Bardi.
I am trying to find the value with the highest number of matching digits but that is smaller than my expression. I am trying with the Index function but can't make it work.
These are my reference :
Code Id.
44010000 176
44011000 3
44012100 2
44012200 4
44013100 5
44013900 6
44030000 177
44032000 194
Now I have the following number for which I want to find the id :
44013010
The result I want to get is id 176 because there is a match on the first 5 digits for 44013100 but 44013100 is higher 44013010, so I refuse that match and need to match on 4 digits on 44010000.
Can anyone help?
Thanks,
Bardi.