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

[raeish]

	A	B	C	D	E	F	G	H	I	J
1 ​	ID	DATE1 ​	WEIGHT1​	DATE2​	WEIGHT2 ​	DATE3​	WEIGHT3​	DATE4​	WEIGHT4​	ARRIVAL DATE ​
2 ​	12345678	43108.55 ​	60​	39681.38 ​	62​	38227.88 ​	58​	42507.28 ​	61​	41109.58 ​
3 ​	23456781	42509.9 ​	100 ​	42634.77 ​	111 ​	41948.6 ​	105 ​	40128.4 ​	112 ​	42634.77 ​
4 ​	34567812	42234.54 ​	45 ​	41578.41 ​	46 ​	38087.28 ​	45.5 ​	41733.03 ​	47 ​	38087.28 ​
5 ​	45678123	40842.34 ​	58 ​	42575.53 ​	57 ​	41221.33 ​	58.5 ​	42003.35 ​	58 ​	41221.33 ​
6 ​	56781234	42025.37 ​	65 ​	39900.69 ​	66 ​	40925.14 ​	65 ​	41464.54 ​	67 ​	42025.37 ​
7 ​	67812345	39075.54 ​	70 ​	43005.43 ​	71 ​	41185.52 ​	69 ​	38821.74 ​	70 ​	38821.74 ​
8 ​	78123456	40477.9 ​	150 ​	39074.11 ​	151 ​	39310.43 ​	153 ​	41505.26 ​	150 ​	39074.11 ​
9 ​	81234567	37998.55 ​	92 ​	41824.97 ​	89 ​	42626.11 ​	93 ​	41051.34 ​	92 ​	42515.49 ​

<tbody>
</tbody>

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