Lookup Column Data

[pilot330]

Hello,

I'd be very grateful for a formula to improve functionality on my spreadsheet please.

At the moment (COL X) contains a formula that scans down the individual horses (COL L) best rating in the previous 12 months (COL V) and inserts it there.

What I would like to do now is put a formula in (COL Y) that reports the OR (COL W) for the corresponding value in (COL V)
If there are equal highest values in (COL V) then the highest corresponding OR in (COL W) is reported in (COL Y)

Thanks very much

 

[pilot330]

HA FLAT AW EXPORT.csv
	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
14	09/03/2021	16:40	7	A Go Go	0	27	24	0	0	5	77	12	10	54	65	78
15	10/02/2021	18:45	4	A Go Go	0	10	4.84	0	0	2	78	27	8	72	67	78	64
16	31/01/2021	14:40	5	A Go Go	0	2	16.81	0	0	7	1			73	68	78
17	29/01/2021	14:25	9	A Go Go	0	33	9.8	0	0	3	76		6	59	68	78
18	27/12/2020	13:50	9	A Go Go	0	8	9.54	0	0	1	1			58	68	78
19	19/12/2020	11:45	1	A Go Go	0	19	6.12	1	0	1	1			78	64	78
20	30/11/2020	16:20	1	A Go Go	0	13	5.63	1	0	2	1			74	59	78
21	17/11/2020	12:20	6	A Go Go	0	4	11.19	0	0	3	1			55	60	78
22	13/11/2020	16:15	2	A Go Go	0	27	7	0	1	1	1			78	60	72
23	17/10/2020	19:00	2	A Go Go	0	12	8.44	0	1	1	70	60	13	70	60	72
24	05/10/2020	16:15	1	A Go Go	0	21	7	1	0	1	64	56	10	72	55	65
25	14/09/2020	17:10	4	A Go Go	6	5	15.28	0	0	1	64	42	8	54	57	65
26	09/09/2020	16:00	1	A Go Go	0	33	6.76	1	0	3	62	38	9	65	51	65
27	07/08/2020	17:50	9	A Go Go	0	7	7.6	0	0	2	62	30	7	48	53	65
28	31/07/2020	16:15	6	A Go Go	0	17	24.48	0	0	6	67	34	6	38	56	65
29	14/07/2020	13:05	6	A Go Go	0	4	38	0	0	1	65	49	4	55	59	65
30	10/07/2020	17:35	7	A Go Go	0	137	22.8	0	0	8	71	41	4	40	59	65
31	24/02/2020	18:00	2	A Go Go	0	7	9.36	0	1	3	63	49	5	65	57	62
32	17/02/2020	16:45	6	A Go Go	0	13	16.62	0	0	4	69	45	5	52	57	62
33	04/02/2020	17:25	5	A Go Go	0	10	8.03	0	0	6	67	58	5	57	57	62
34	25/01/2020	17:00	2	A Go Go	0	12	15.5	0	1	7	75	20	5	62	57	62
35	13/01/2020	13:25	2	A Go Go	0	5	3.67	0	1	3	64	40	3	62	56	56
36	08/01/2020	17:15	6	A Go Go	0	30	25.27	0	0	6	68	47	3	54	56	56
37	09/12/2019	16:45	3	A Go Go	0	52	20.29	0	1	5	65	67	-1	56	55	53
38	18/10/2019	17:25	7	A Go Go	0	15	16	0	0	8	81	59	1	44	55	53
39	03/10/2019	17:10	1	A Go Go	0	18	24	1	0	10	64	59	-5	53	51	45
40	15/09/2019	14:05	5	A Go Go	0	45	60	0	0	5	67	35	-3	45	54	44
41	01/08/2019	18:10	7	A Go Go	0	8	70.23	0	0	2	81		53	14	0	44
42	24/07/2019	14:10	6	A Go Go	0	53	95	0	0	1	78		999	44	0	24
43	01/06/2019	18:45	5	A Go Go	0		29.32	0	0	1	83		0	24	0	0
44	22/10/2019	17:30	3	A Hundred Echoes	0	32	5.85	0	1	5	62	56	3	60	52	56
45	20/09/2019	20:20	10	A Hundred Echoes	0	14	22.25	0	0	2	65	37	-1	51	54	56
46	06/09/2019	16:55	8	A Hundred Echoes	0	18	22	0	0	8	69	39	-4	51	57	56
47	19/08/2019	16:15	4	A Hundred Echoes	0	94	21	0	0	1	79		53	43	0	56
48	17/05/2019	15:55	11	A Hundred Echoes	0	42	118.23	0	0	1	89		999	56	0	0
HA FLAT AW EXPORT

 

[pilot330]

Any help on this one appreciated, thanks.