Help! LOL

Forum for RI subscribers only
dobbin1950
Posts: 5
Joined: Fri Feb 05, 2016 1:29 pm
Location: Glasgow

Help! LOL

Postby dobbin1950 » Wed Jul 27, 2016 8:51 am

Hi Folks,

Hope you are all well.

I am looking to update one of my Excel files from another results file I have.

I have all of my own rating results going back to 2013 which includes the odds of each runner.

I have another file of Datasets including RI Data.

What I need to do is pull the results from The first File into the second file bearing in mind that first file has non runners deleted and the other does not.

I had a look at using Vlookup but did my head in LOL.

Any Ideas folks

Dobbin
When all else fails, read the Instructions.

Provideo
Posts: 2
Joined: Tue May 10, 2016 1:53 pm

Re: Help! LOL

Postby Provideo » Sat Jul 30, 2016 7:52 am

Hi Dobbin

If you could post the layout of both files and what you are trying to match, I may be able to help.

Cheers
Provideo

dobbin1950
Posts: 5
Joined: Fri Feb 05, 2016 1:29 pm
Location: Glasgow

Re: Help! LOL

Postby dobbin1950 » Sat Jul 30, 2016 8:13 am

HI Provideo,

Out to get the worms Eh! LOL

Thanks for having a look at it

The File with all of the odds in is Ratings results laid out as follows.

Date Meeting Time H/Cap Class Age Code Dist Run Type1 Type2 Type3 No Horse Form Grade Distance Going Speed Rating Rated Won Odds Return Draw Trainer Jockey

The Main file I have without all of the odds is laid out as follows

Date Meeting Time H/Cap Class Age Code Dist Run Type Type1 Type2 No Horse Lm Cr Cl To TS TF TT CH UN RF RS RT Total RTD Master M+A Lto BD Won Odds Return DT Gold 5* Draw CD Eve Trainer Jockey


What I am am looking to do is to pull the contents of "Won", "Odds" and Return from the Ratings Results file into the Main file where applicable.

If that makes sense the way I have explained it

Dobbin
When all else fails, read the Instructions.


Return to “Registered Members Only Forum”

Who is online

Users browsing this forum: No registered users and 0 guests