Celticshadow
Active Member
- Joined
- Aug 16, 2010
- Messages
- 414
- Office Version
- 365
- Platform
- Windows
Hi All
I would like to have a formula that looks up the horse Priory in workbook 1 and finds its speed value in workbook 2 (col H)
from the most recent date and place it in workbook 1 col H2. Unfortunately I am unable to sort workbook two but can sort workbook one in ascending order by horse name, also the dates in workbook two are in ascending order. I have attached an example as below and hope that helps with my query. Many thanks in advance.
Regards
Workbook 1
<tbody>
</tbody>
Workbook 2
<tbody>
</tbody>
I would like to have a formula that looks up the horse Priory in workbook 1 and finds its speed value in workbook 2 (col H)
from the most recent date and place it in workbook 1 col H2. Unfortunately I am unable to sort workbook two but can sort workbook one in ascending order by horse name, also the dates in workbook two are in ascending order. I have attached an example as below and hope that helps with my query. Many thanks in advance.
Regards
Workbook 1
ID | Rnnrs | DATE | COURSE | TIME | NO | HORSE | Speed Fig Required |
1 | 5 | 10 June 2015 | Beverley | 1400 | 4 | Priory | 15 |
1 | 5 | 10 June 2015 | Beverley | 1400 | 6 | Lolamotion | |
1 | 5 | 10 June 2015 | Beverley | 1400 | 1 | Mustnt Grumble |
<tbody>
</tbody>
Workbook 2
ID | Rnnrs | DATE | COURSE | TIME | NO | HORSE | SPEED |
870 | 5 | 07 April 2015 | Lingfield | 1510 | 5 | Priory | 0 |
2,001 | 9 | 09 May 2015 | Goodwood | 1445 | 9 | Priory | 80 |
3,126 | 8 | 01 June 2015 | Windsor | 1755 | 5 | Priory | 15 |
<tbody>
</tbody>