![Old](images/statusicon/post_old.gif)
9th May 2014, 11:21 AM
|
Member
|
|
Join Date: Jan 1970
Location: Western Australia
Posts: 3,455
|
|
Excel Formula Help
I have an issue and not sure of the best formula to use.
I need to do a double look up, i have a list of races and the selections going down the page and need to lookup a runner using the race name as the first lookup then continue down and use the runner number as the second look up, the info i need will be located 5 rows over from this.
I have used a formula like this before.
=INDEX($AA$1:$AT$499,MATCH($BD3,$Z$1:$Z$499,0)+4,9 )
This would only work if i knew where the info was in relation to the race name, hope u understand what i need.
__________________
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
_______________________________________________
|