Matching Names With Figures

[mlmrob]

Good Evening Guys

I have a spreadsheet with Performance Figures of every racehorse to have run in the UK this year.

What I want to do is match the horse and its figures with the list of those horses running today.

In A is the list of every horse in the UK
In columns B to G are the Performance Figures. The latest being in B
In column H and I are the time of the race today and the track the horse is running at
Column J is a list of horses running that are running on the day

The sheet can be found here

Performance.xlsx

Microsoft Excel Workbook

1drv.ms

I have tried using the below formula but I only get some Performance Figures.

=INDEX($A$2:$B$1253,MATCH(J2,$A$2:$A$1253,0),2)

Any help would be appreciated

Thank You

Rob

 

[Fluff]

You need to expand the range

=INDEX($B$2:$B$12531,MATCH(J2,$A$2:$A$12531,0))

 

[mlmrob]

Thanks Fluff

Thast works a treat for the latest figures, how would I gather the figures for the other races?

Thanks again, very much appreciated

Rob

 

[mlmrob]

You need to expand the range

=INDEX($B$2:$B$12531,MATCH(J2,$A$2:$A$12531,0))

Fluff, when I have done this today I have been getting the following

Below are Atomise Figures, so I should get 67. Any ideas what I am doing wrong. Thanks.

 

[Fluff]

On the file you supplied Atomise has (GB) after it in column A, so you could try

=INDEX($B$2:$B$12531,MATCH(IF(ISERR(FIND("(",J2)),J2 & " (GB)",J2),$A$2:$A$12531,0))

 

[mlmrob]

On the file you supplied Atomise has (GB) after it in column A, so you could try

=INDEX($B$2:$B$12531,MATCH(IF(ISERR(FIND("(",J2)),J2 & " (GB)",J2),$A$2:$A$12531,0))

Yeah I noticed that after I had posted. I took the (GB) away to no avail but your new formula has worked a treat.

Would I get the rest by just changing column B to column C on the formula and so on

Thanks again for your help, it is as always appreciated

 

[Fluff]

You could do that, or you could use

=XLOOKUP(IF(ISERR(FIND("(",J2)),J2 & " (GB)",J2),$A$2:$A$12531,$B$2:$G$12531,"not found")

which will spill across.

 

[mlmrob]

That's perfect, thank for your patience and help.

Kindest Regards

Rob

 

[Fluff]

You're welcome & thanks for the feedback.