Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.