Index match Nested in an if formula

[DWB82]

Hi All

I am hoping that somebody can help me with a formula that I am having a little difficulty with. I am sure that I can not see the answer for looking!!

I have this formula "=IF($A5="Spare","",(IFERROR(IF(INDEX('All Holiday'!$D$3:$OR$536,MATCH('Core Rotas'!$B5,'All Holiday'!$B$3:$B$536,0),MATCH('Core Rotas'!E$2,'All Holiday'!$D$2:$OR$2,0))="HOL","HOL",(INDEX('Tornado Rotas'!$D$2:$OR$272,MATCH('Core Rotas'!$B5,'Tornado Rotas'!$B$2:$B$272,0),MATCH('Core Rotas'!E$2,'Hurricane Rotas'!$D$1:$OR$1,0)))),"A")))"

I would like to add in another condition like with "HOL" but using Half instead. I have tried a number of ways but can not seem to get it to work.

If any one could help it would be really appreciated!!!

Thanks in advance

 

[Legacy 396030]

It would be better to show an example of what you want perhaps a screen shot or html.