In a formula with 8 IF queries, for example
=IF(B13="Blah",Blah!$C$37,IF(B13="Stuff",Stuff!$C$ 37)) etc, how do I replace
all the cell references (say $C$37) in one go, without having to overwrite
each one separately?
I tried highlighting the formula then utilising Find & Replace in the Edit
menu (which has a option to look in formulas) to no avail.
Would appreciate assistance ans there are tonnes to change