Switch lookup function to another sheet
 

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!

Switch lookup function to another sheet
 

Select the range
and Edit|Replace

Seems like a quick way to me.

New2Macros wrote:

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

Switch lookup function to another sheet
 

Hi

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


Arvi Laanemets



"New2Macros" wrote in message
...
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!