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