
13th March 2012, 09:35 PM
|
Member
|
|
Join Date: Jan 1970
Location: Western Australia
Posts: 3,403
|
|
I made a small update to the program but won't upload a new one i will just tell you what to do.
On the "MainSheet" in cell Y31 replace the formula with this.
=IF($S$16="","",IF(ISNA(VLOOKUP(U31,$U$18:$X$21,4,FALSE)),"",VLOOKUP(U31,$U$18:$X$21,4,FALSE)))
Then click the bottom right corner of the cell and drag it down to Y38
What it does is pick up on the 4th place horse and puts in a zero just so you know the selection on the results page.
__________________
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
_______________________________________________
|