Moee, could you not just have an a4 sheet that has a series of tables that you just tick or cross or highlight for dogs of note when you have watched a race once, instead of viewing it a number of times,

I toyed with the idea and bull********ted myself that I was going to write notes beside every dog in my database as to running patterns and quirks.
It never happened.
It never will.

I can't explain why.

I dig holes in the back yard and fill them up with dirt from the front yard.
The backyard dirt I bag and throw in the wheelie bin.

I can't explain why.

My Mother suggested it is her fault that I fell on my head at 4 years of age.
It wasn't.
But the incident could explain why I can't explain.

Racing is back tomorrow.
I totally enjoyed todays break.
I totally enjoyed Ravens assistance.

I am copping a hiding and have been for almost a month.
It ends today.
Look for my posts tomorrow everyone if you want some encouragement.

In an 8 horse field there are 56 different possible Box Trifecta Combinations that can occur

I have a Race with 8 greyhounds in it.
In SHEET 1 I have Column A with the Box Numbers and in Column B I have the animals names.
So A1 contains 1 and B1 contains "DOG NAME"

In SHEET 2 I want to do this.
I have written down all the 56 possible Box Trifectas - 123, 124 , 125....678
That is in Columns A,B,C
What I wish to do is have an animals name appear in a Column E when the animals Box Number is in Column A
And So with Column F and Column G.

What Formula do I put in SHEET2 E1?
and then copy that Formula through Column EFG.

i managed to get something happening with the VLOOKUP Function.
But its not how I wish to do it.

What I want is like this Formula.
=C1
But instead of the 1 its looks in Cell A1 to find the number.
Like =C"A1" or =C(A1) or ="C"(A1)
And A1 would contain a number.

Thanks for your help whoever may have tried.
But no need assistance anymore.

I managed to find something in the EXCEL Help.
Its called the OFFSET Function.
=OFFSET(F1,A1,0) pretty much does it for me.

Cheers