Matching values of two list

Hi Everyone,

i am trying to match values from list 2 to match with list 1 (list values are length in mm)

Condition to match values is

  • value should be equal to or lest than equal to -20mm
  • or the closet value
    and get the matched list.

If anybody has tried something similar kindly share your ideas , drop a link.

Thank you so much.

to make it more clear –

if considered
list_1 =x and list_2 = y
Condition to match values is
match y values to x
match the closet value , closest value should be be more than +20mm
and get the matched list.

If anybody has tried something similar kindly share your ideas , drop a link.

Thank you so much.

Hi,
You can do it like that.

1 Like

@patrykrosi
thank you for your quick response,
referring to my image in first post -
list 1 has 40 values
list 2 has 22 values

i have to match list 2 values with list 1
condition to match values is like
i need to check each value in list 2 if they match with list 2
values in list 2 should be less than or equal value in list 1 to match.but when i say less than i am ranging the each list one value as (x to x-10 with step as 1).(ex. value 354 range will be from 344, 345, 346, 347…354)
value from list 2 will match with list 1 only if its equal or fall in that range

as a result only few of list 2 will match with list 1.

i hope its clear now,

Hi,

this was how i was able to match and get the values …
can any body tell be how else could it be done better.

thank you,