Want cell references to reset if IF logic test is true

[reasem]

Hello, I'm looking for a formula where the formula in the true part of the IF statement will only start if the test results in blank (""). What I mean by this is that I'm using a cell reference (AD2) in my formula for the true part of the statement and when I drag my formula down the AD2 will change into something like AD35. I know this is how excel works but I'm looking for the formula to "reset" at AD2 if the logical test returns a blank.

 

[DanteAmor]

I did not understand well.
You can put your formula.
You can give an example if the result is blank ("") then what should the formula get; and if the result is different from blank ("") then what result should the formula get.
You can paste a sample of data here to explain more clearly what you require.

 

[reasem]

Here is an example of the formula on line 35 of my array if you will. This IF statement should be true--I now want the "row" in the index function (bolded) to start at AD2. I need the formula to be uniform as the data I'm using will change so I can't change it to AD2 manually.

=IF(IFERROR(INDEX('AMAs on File'!$2:$1048576,'AMAs on File'!$AB35,4),"")="",INDEX('AMAs on File'!$2:$1048576,'AMAs on File'!$AD35,4),IFERROR(INDEX('AMAs on File'!$2:$1048576,'AMAs on File'!$AB35,4),""))

 

[DanteAmor]

I'm trying to understand.
If the result is "", then AD2

=IF(IFERROR(INDEX('AMAs on File'!$2:$1048576,'AMAs on File'!$AB35,4),"")="",INDEX('AMAs on File'!$2:$1048576,'AMAs on File'!$AD$2,4)

In which case should it be AD35?

 

[reasem]

I'm trying to understand.
If the result is "", then AD2

=IF(IFERROR(INDEX('AMAs on File'!$2:$1048576,'AMAs on File'!$AB35,4),"")="",INDEX('AMAs on File'!$2:$1048576,'AMAs on File'!$AD$2,4)

In which case should it be AD35?

I'm trying to understand.
If the result is "", then AD2

=IF(IFERROR(INDEX('AMAs on File'!$2:$1048576,'AMAs on File'!$AB35,4),"")="",INDEX('AMAs on File'!$2:$1048576,'AMAs on File'!$AD$2,4)

In which case should it be AD35?

Almost. I want the formula to start at AD2 if the statement is true. The formula is dragged down to line 100. The next formula should be AD3 then AD4 and so on

 

[DanteAmor]

if the statement is true

If the statement is true, If you drag the formula then keep $AD$2 ...
Then at some point the result of the formula will be false ...
If you drag the formula then it must be D3, D4 ...


I'm thinking it would be possible but with a macro.
1. Select the cells where you want the formula.
2. Press a button to run the macro.
3. The macro would evaluate if the statement is true, then create the formula with $D$2.
4. If the evaluation of the statement is false then the macro would create the formula with D3, D4 ... until the cell you have selected.

Something like that you need?