Forum Discussion
Easy way to Replace value in fomula
Hello, In cells H5:H89, Is there an easy way I can change $B$2 and $C$2 in the formula to $G$2 and $H$2 without tempering any other part of the formula especially the 'query result'!$C:$C,"*TEXT*...
little2fern Unless I am totally misreading your question (and picture), I would say to just edit the formula in H5 and copy it down.
Had you written the formula in C5 with references like C$2 and D$2 (so skipping the first $ sign), you could just have copied C5:C89 on to H5.