Switch lookup function to another sheet

[New2Macros]

I have a sheet which is looking up data from another sheet, and I want change
that "lookup sheet." How do I do this quickly?

Example: =LOOKUP($A1,'Sheet 1 Original'!B1:B3,'Sheet 1 Original'!C1:C3)

I want to change that "Sheet 1 Original" reference to "Sheet 1 New," in 100
cells at once. Thanks!

 

[Dave Peterson]

Select the range
and Edit|Replace

Seems like a quick way to me.

 

[Arvi Laanemets]

Hi

Select the renge with formulas.
Replace> Find what = "Sheet 1 Original" , Replace with = "Sheet 1 New"

Replace All

Arvi Laanemets