Hi,
I have dozens of formula like this:
VLOOKUP($A22,'sample'!$A$302:$Z$302,2,FALSE), except $A$302:$Z$302 might
change like $A$50:$Z$51, picking up from different area.
Now I want to replace above formula like this:
VLOOKUP($G13,INDIRECT(Fcst&"!$b$20:$z$30"),2,FALSE ) but I won't change area.
Because there are so many formula, I want to change them in a batch, I try to
use replace (ctrl+R), but it doesn't work because I only want to replace
'sample'!$ with INDIRECT(Fcst&"!
I got error message because I can't replace including ")

Is there a way to change this formula in a batch?