Hello, Seeking some assistance please.
I have a formula which creates either a name or a blank “” in cell AB18.I wish to combine the result of that cell with the larger formula.

If AB18 is blank then carry out the second if below.
If AB18 has a combination of number and text (2. redcoat ). Then do not carry out the the second if

=IF($AC16-$AD16<3,"",INDEX(pbet!$C$1:$C$1463,$AD16+COLUMNS($AB13:AB13)))