| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup single value in one sheet, return multiple results from theother sheet | Excel Worksheet Functions | |||
| Lookup function from a different sheet! | Excel Worksheet Functions | |||
| Excel: Arrows scroll sheet instead of move cursor. How to switch | Excel Discussion (Misc queries) | |||
| How can I switch the pmt function to calculate based on a 360 day | Excel Worksheet Functions | |||
| Switch function | Excel Worksheet Functions | |||
Threaded Mode
