31st May 2006, 10:36 AM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 578
|
|
Quote:
|
Originally Posted by moeee
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. |