How to find weight value measured on the nearest date to another date?

[raeish]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[TD]I
[/TD]
[TD]J
[/TD]
[/TR]
[TR]
[TD]

1
​

[/TD]
[TD]ID
[/TD]
[TD]

DATE1
​

[/TD]
[TD]

WEIGHT1​

[/TD]
[TD]

DATE2​

[/TD]
[TD]

WEIGHT2
​

[/TD]
[TD]

DATE3​

[/TD]
[TD]

WEIGHT3​

[/TD]
[TD]

DATE4​

[/TD]
[TD]

WEIGHT4​

[/TD]
[TD]

ARRIVAL DATE
​

[/TD]
[/TR]
[TR]
[TD]

2
​

[/TD]
[TD]12345678
[/TD]
[TD]

43108.55
​

[/TD]
[TD]

60​

[/TD]
[TD]

39681.38
​

[/TD]
[TD]

62​

[/TD]
[TD]

38227.88
​

[/TD]
[TD]

58​

[/TD]
[TD]

42507.28
​

[/TD]
[TD]

61​

[/TD]
[TD]

41109.58
​

[/TD]
[/TR]
[TR]
[TD]

3
​

[/TD]
[TD]23456781
[/TD]
[TD]

42509.9
​

[/TD]
[TD]

100
​

[/TD]
[TD]

42634.77
​

[/TD]
[TD]

111
​

[/TD]
[TD]

41948.6
​

[/TD]
[TD]

105
​

[/TD]
[TD]

40128.4
​

[/TD]
[TD]

112
​

[/TD]
[TD]

42634.77
​

[/TD]
[/TR]
[TR]
[TD]

4
​

[/TD]
[TD]34567812
[/TD]
[TD]

42234.54
​

[/TD]
[TD]

45
​

[/TD]
[TD]

41578.41
​

[/TD]
[TD]

46
​

[/TD]
[TD]

38087.28
​

[/TD]
[TD]

45.5
​

[/TD]
[TD]

41733.03
​

[/TD]
[TD]

47
​

[/TD]
[TD]

38087.28
​

[/TD]
[/TR]
[TR]
[TD]

5
​

[/TD]
[TD]45678123
[/TD]
[TD]

40842.34
​

[/TD]
[TD]

58
​

[/TD]
[TD]

42575.53
​

[/TD]
[TD]

57
​

[/TD]
[TD]

41221.33
​

[/TD]
[TD]

58.5
​

[/TD]
[TD]

42003.35
​

[/TD]
[TD]

58
​

[/TD]
[TD]

41221.33
​

[/TD]
[/TR]
[TR]
[TD]

6
​

[/TD]
[TD]56781234
[/TD]
[TD]

42025.37
​

[/TD]
[TD]

65
​

[/TD]
[TD]

39900.69
​

[/TD]
[TD]

66
​

[/TD]
[TD]

40925.14
​

[/TD]
[TD]

65
​

[/TD]
[TD]

41464.54
​

[/TD]
[TD]

67
​

[/TD]
[TD]

42025.37
​

[/TD]
[/TR]
[TR]
[TD]

7
​

[/TD]
[TD]67812345
[/TD]
[TD]

39075.54
​

[/TD]
[TD]

70
​

[/TD]
[TD]

43005.43
​

[/TD]
[TD]

71
​

[/TD]
[TD]

41185.52
​

[/TD]
[TD]

69
​

[/TD]
[TD]

38821.74
​

[/TD]
[TD]

70
​

[/TD]
[TD]

38821.74
​

[/TD]
[/TR]
[TR]
[TD]

8
​

[/TD]
[TD]78123456
[/TD]
[TD]

40477.9
​

[/TD]
[TD]

150
​

[/TD]
[TD]

39074.11
​

[/TD]
[TD]

151
​

[/TD]
[TD]

39310.43
​

[/TD]
[TD]

153
​

[/TD]
[TD]

41505.26
​

[/TD]
[TD]

150
​

[/TD]
[TD]

39074.11
​

[/TD]
[/TR]
[TR]
[TD]

9
​

[/TD]
[TD]81234567
[/TD]
[TD]

37998.55
​

[/TD]
[TD]

92
​

[/TD]
[TD]

41824.97
​

[/TD]
[TD]

89
​

[/TD]
[TD]

42626.11
​

[/TD]
[TD]

93
​

[/TD]
[TD]

41051.34
​

[/TD]
[TD]

92
​

[/TD]
[TD]

42515.49
​

[/TD]
[/TR]
</tbody>[/TABLE]

Hello

Above is a table representing the data I'm looking at(in a lot smaller scale). I wish to create a list of the weights measured on the date closest to the "arrival date" for the specific IDs.
My dates are in numbers.

I have tried combining the =INDEX() and =MATCH() and =OFFSET() functions but can't seem get the right result.

Hope someone out there can help

Kind regards,
Rae