Excel Trigger

[sjaak1943]

=IF(AND($B$55=F5,$D$58=$B$58),"LAY"," ")

is my LAY-trigger.

On another sheet (Excl_horses) I have a list of horses ($A$1:$A$50), I don't want to lay.

How can I implement that in my LAY-trigger.
I tried with VLOOKUP, but could not manage it.
Who helps me out?
Thanks,

Sjaak

[sjaak1943]

Please?!

[GaryRussell]

VLOOKUP is the way to go.

For example (10 horses in the list)

=VLOOKUP(A5,Excl_horses!A$1:A$10,1,FALSE) in cell Z5
=IF(ISERROR(Z5),0,1) in cell AA5

Cell AA5 will contain 0 if not in the list and 1 if found in the list.

Your trigger could then read as follows.

=IF(AND($B$55=F5,$D$58=$B$5,AA5=0),"LAY"," ")

[sjaak1943]

Thanks Gary!

Sjaak

[sjaak1943]

Something strange happens with the code:

=VLOOKUP(A5,Excl_horses!A$1:A$30,1,FALSE)

After a few races the code is changed in for example:

=VLOOKUP(A5,Excl_horses!A$1:A$4,1,FALSE)

Don't know why, but I have to change it an inspect it very often.

Who knows why?

Sjaak

[alrodopial]

Do you delete entire rows in Excl_horses! sheet? From 1st row to 30 row?

[sjaak1943]

I found the problem.
It has to do with making a list of selected horses every day.
I have to make it it in another worksheet and then copy it in the BA sheet.

Thanks,

Sjaak