Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question

migrated from stackoverflow.com Jun 30 '11 at 10:53

This question came from our site for professional and enthusiast programmers.

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

enter image description here

share|improve this answer

You can still do search and replace on cells with a formula. It will be applied to the forumla, not the result you see. Try it out and see if it works.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .