Switch lookup function to another sheet

N

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top