I need help nesting this "IF" formula

[valmir]

Hello everyone:
Please help me nest this "IF" formula as follows:
IF
LOGICAL TEST

INDEX(INDIRECT($A24&"!$R$51"):INDIRECT($A24&"!$DO$51"),1,MATCH(INDIRECT($A24&"!$HI$8"),INDIRECT($A24&"!$R$2"):INDIRECT($A24&"!$DO$2"),0)+2)<0

VALUE IF TRUE

INDEX(INDIRECT($A24&"!$R$51"):INDIRECT($A24&"!$DO$51"),1,MATCH(INDIRECT($A24&"!$HI$8"),INDIRECT($A24&"!$R$2"):INDIRECT($A24&"!$DO$2"),0)+2)

VALUE IF FALSE

TEXTJOIN("-",TRUE,INDIRECT($A24&"!$HQ$8"),INDIRECT($A24&"!$HR$8"))

Thanks!

 

[etaf]

Not sure what you mean BY Nest
I have simply appled to an IF( TEST, TRUE, FALSE)
what are you getting ????? that means you need a NEST


= IF ( INDEX(INDIRECT($A24&"!$R$51"):INDIRECT($A24&"!$DO$51"),1,MATCH(INDIRECT($A24&"!$HI$8"),INDIRECT($A24&"!$R$2"):INDIRECT($A24&"!$DO$2"),0)+2)<0 , INDEX(INDIRECT($A24&"!$R$51"):INDIRECT($A24&"!$DO$51"),1,MATCH(INDIRECT($A24&"!$HI$8"),INDIRECT($A24&"!$R$2"):INDIRECT($A24&"!$DO$2"),0)+2),TEXTJOIN("-",TRUE,INDIRECT($A24&"!$HQ$8"),INDIRECT($A24&"!$HR$8")))

I'm assuming each of the formulas works when on there OWN , i have not checked the formulas at all - just applied to an IF()

May need and iferror to allow for the index NOT to find anything

=IFERROR (IF ( INDEX(INDIRECT($A24&"!$R$51"):INDIRECT($A24&"!$DO$51"),1,MATCH(INDIRECT($A24&"!$HI$8"),INDIRECT($A24&"!$R$2"):INDIRECT($A24&"!$DO$2"),0)+2)<0 , INDEX(INDIRECT($A24&"!$R$51"):INDIRECT($A24&"!$DO$51"),1,MATCH(INDIRECT($A24&"!$HI$8"),INDIRECT($A24&"!$R$2"):INDIRECT($A24&"!$DO$2"),0)+2),TEXTJOIN("-",TRUE,INDIRECT($A24&"!$HQ$8"),INDIRECT($A24&"!$HR$8"))) , "")

 

[valmir]

Not sure what you mean BY Nest
I have simply appled to an IF( TEST, TRUE, FALSE)
what are you getting ????? that means you need a NEST


= IF ( INDEX(INDIRECT($A24&"!$R$51"):INDIRECT($A24&"!$DO$51"),1,MATCH(INDIRECT($A24&"!$HI$8"),INDIRECT($A24&"!$R$2"):INDIRECT($A24&"!$DO$2"),0)+2)<0 , INDEX(INDIRECT($A24&"!$R$51"):INDIRECT($A24&"!$DO$51"),1,MATCH(INDIRECT($A24&"!$HI$8"),INDIRECT($A24&"!$R$2"):INDIRECT($A24&"!$DO$2"),0)+2),TEXTJOIN("-",TRUE,INDIRECT($A24&"!$HQ$8"),INDIRECT($A24&"!$HR$8")))

I'm assuming each of the formulas works when on there OWN , i have not checked the formulas at all - just applied to an IF()

May need and iferror to allow for the index NOT to find anything

=IFERROR (IF ( INDEX(INDIRECT($A24&"!$R$51"):INDIRECT($A24&"!$DO$51"),1,MATCH(INDIRECT($A24&"!$HI$8"),INDIRECT($A24&"!$R$2"):INDIRECT($A24&"!$DO$2"),0)+2)<0 , INDEX(INDIRECT($A24&"!$R$51"):INDIRECT($A24&"!$DO$51"),1,MATCH(INDIRECT($A24&"!$HI$8"),INDIRECT($A24&"!$R$2"):INDIRECT($A24&"!$DO$2"),0)+2),TEXTJOIN("-",TRUE,INDIRECT($A24&"!$HQ$8"),INDIRECT($A24&"!$HR$8"))) , "")

Perfect! You saved my day! Thank you so much!

 

[etaf]

you are welcome