Hi all!
At times it is necessary to overwrite a formula in a cell. I would like a simple way to replace the formula when necessary. I would like to double click in the cell to replace the formula.
Row 3 is the first row where this formula starts. It would need to be relative.
=IFERROR(INDEX(Instruments!$AW$3:$AW$40,MATCH('Patch By UNIVERSE'!A3,Instruments!$A$3:$A$40,1)),"")
Thank you!
At times it is necessary to overwrite a formula in a cell. I would like a simple way to replace the formula when necessary. I would like to double click in the cell to replace the formula.
Row 3 is the first row where this formula starts. It would need to be relative.
=IFERROR(INDEX(Instruments!$AW$3:$AW$40,MATCH('Patch By UNIVERSE'!A3,Instruments!$A$3:$A$40,1)),"")
Thank you!