Excel search help needed
 

EXCEL HELP

Sheet 1.
Column A contains a list of horses mames
Column B contains each horses rating

Sheet 2.
Column A contains the names of Runners in todays Race

QUESTION.
How can I get program to search Sheet 1 and install appropriate Rating into Column B in Sheet 2.?

Perhaps someone could be kind enough to create a Macro for me please?

Just use the following:

=LOOKUP(Sheet2!A1,Sheet1!A1:Sheet1!A3,2)

This formula should be placed on Sheet2 cell B1 etc.

That should do it, but I would actually name your sheets.

Also the A3 in the formula should represent the last cell reference of where a horse is named, so if you have 100 horses listed and the last one is located in cell A100, then that's the cell reference which should be used in the formula above.

Youur a fine man La Mer.
I'll go plug that in now.
If it works....I'lll email you a percentage of my winnings!
Thanks buddy!

That will work well, but if you have a very long list of horses and you intend adding to it, you might be better to set it up in Access with a relationship based on the horse name.

So you would have a tblHorse and tblRace joined in a relationship by the fields Horse and run aquery from there.

It would save errors and it's easy to import excel sheets to Access.

Just a suggestion.

Bit of tinkering and reading got it to work like this.

=LOOKUP(Sheet2!A1,Sheet1!A1:Sheet1!A3,2)...Yours
=LOOKUP(A1,'Race Records'!A$1:A$320,'Race Records'!B$1:B$320)...Mine

Thanks for the legup La Mer.

Maybe enough with the Programs Chrome Prince.
Ain't worked Excel out yet...Frightened to try learning another one.

Just a suggestion, as you're going to get really upset when your excel file corrupts and you lose all the data - I know, it happened to me.

I can knock you up a program if you want for nix, it'll take me a few days coz I'm busy with work, but the offer is there. You don't need to send me your ratings, just send me a spreadsheet with phantom ratings, so I know exactly what you need.

racestats at hotmail dot com

If you'd rather just go with what you've got, then make sure you backup the excel book regularly onto a flash drive and keep at least two backup copies at all times.

Thanks anyway.

I'm actually using Kennedys Greyhound system.
Remember the one?
Don't know if he got further with it,he seems to have disappeared.
He didn't want it to spread to much more around so I wish to respect his wish.
Just been modifying it.
Still comes up as a loser but who knows?