Find matching value in one column to copy adjacent cell on same row

In B1

=IFERROR(INDEX(D:D,MATCH($a1,$F:$F,0)),"")

Copy down and across

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.

Hello
I am after a similar solution:
A1 B1 Updates sheet
Aintree 58.07%
Ascot 61.67%
Ayr 66.10%
Bangor 67.95%
Carlisle 70.80%
Cartmel 55.00%
Cheltenham 76.85%
Exeter 72.52%
Fontwell 61.30%
Haydock 67.50%
Haydock 60.00%
Hexham 74.20%
Kelso 57.10%
Kempton 52.50%
Leicester 57.93%
Lingfield 65.86%
Ludlow 62.60%
Market Rasen 56.73%
Newbury 65.97%
Newton Abbot 59.82%
Perth 84.28%
Plumpton 69.57%
Sandown 61.25%
Sedgefield 66.90%
Southwell 73.98%
Stratford 72.05%
Taunton 62.52%
Towcester 62.50%
Warwick 52.55%
Wetherby 60.27%
Race Courses and percentages in sheet 'Updates' to match Courses in sheet 2, then paste percentage in ajacent cell in sheet 2.
A1 B1 SHEET 2
Ludlow
Sedgefield
Wetherby
Hereford
Taunton
Newbury
Limerick
Newbury
Bangor-on-Dee

Originally Posted by dublindub

Hello
I am after a similar solution:
A1 B1 Updates sheet
Aintree 58.07%
...

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread