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?