Excel 2007: How to replace part of formula with another formula

microsoft excelmicrosoft-excel-2007

I need to replace the $D49 with

SERROR(VLOOKUP($B49 & " Total",Flt_S2D1,$Z$47,0)),0,VLOOKUP($B49 & " Total",Flt_S2D1,$Z$47,0))** in below formula.

=IFERROR(IF($Z$38="CBO Dmd",$C49,IF($Z$38="CBO Dmd-Cust Raw",$D49*($Y49/$E49),IF($Z$38="CBO Dmd-Pr CBO",$D49*($X49/$E49),IF($Z$38="CBO Dmd-BAB Grs CGID",$D49*($W49/$E49),IF($Z$38="CBO Dmd-Bill Grs CGID",$D49*($V49/$E49),$D49*($CC49/$E49)))))),0)

I have googled and find some articles to do this, but those are related to replacing a part of formula with calculated result or cell value.

I can replace $D49 with required value by doing multiple times, but is there any way to replace at a time like find and replace all, which we are doing for text replace.

Best Answer

Normal Search and Replace works (shortcut Ctrl+H). Just make sure you choose 'Look in:' Formulas

enter image description here

Related Question