Found It

Parenthesis in the wrong placee

=IF(AND(INDIRECT("'Date
Details'!"&ADDRESS(6,(INT(ROW()/1-45)+2)))="GB",INDIRECT("'Date
Details'!"&ADDRESS(7,(INT(ROW()/1-45)+2)))="Rehearsals"),"Rehearsals",INDIRECT("'Dat e Details'!"&ADDRESS(6,(INT(ROW()/1-45)+2))))

"stew" wrote:

Hi can anybody see an error in this Formula which is in E46 on a different
worksheet

=IF(AND(INDIRECT("'Date
Details'!"&ADDRESS(6,(INT(ROW()/1-45)+2)))="GB",INDIRECT("'Date
Details'!"&ADDRESS(7,(INT(ROW()/1-45)+2))))="REHEARSALS","REHEARSALS",INDIRECT("'Dat e Details'!"&ADDRESS(6,(INT(ROW()/1-45)+2))))

It should do the following
If the 2 conditions
date details C6 =GB AND date details C7 = Rehearsals the result should read
Rehearsals
At the moment it is returning date details C6

Thanks for looking

Stew