View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
New2Macros New2Macros is offline
external usenet poster
 
Posts: 22
Default 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!