Sorry my bad, the column in blue is the reference, as you see there are individual races and each runner has a reference of 1 or 2 so what i need is to say look up the race then look up the runner reference then return the runner name.

Attached Files

Sample.xlsx (9.4 KB, 582 views)

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________