Countif and IF Formula

[adriandiaz]

I am using the following formula
=if(countif('Copy of Portfolio Transactions'!$A:$A,"Avondale Tax*"),'Copy of Portfolio Transactions'!F3,"")
The F3 Row is a dynamic field not static and every time I move the data around I do not get the results. Is there a way I can make it dynamic?

 

[Coding4Fun]

.

 

[Aladin Akyurek]

What this formula says is: if the COUNTIF bit delivers a non-zero count, display F3 of Copy of Portfolio Transactions. Given this, care to elaborate what "The F3 Row is a dynamic field not static and every time I move the data around I do not get the results." means?

 

[adriandiaz]

I am pulling data from Copy of Portfolio Transactions', and place it on another sheet, but the data in "Copy of Portfolio Transactions sheet" always moves around as data is pulled every month and its always in different Cells. The F3 next month can be F6,F7,F8. Always an F, but not in the same row.