| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 SP3 Copy Worksheet with another sheet named range now #
Setup
==== Sheet1 has sheet-specific named range ('Sheet1!MyTab') equal to say A1:B3 = 2 col, 3 row = 1,One ^ 2,Two ^ 3,Three Sheet2!A1 references this range e.g. =HLOOKUP(2.5,Sheet1!MyTab, 2) Sheet2!A2 references this range e.g. =HLOOKUP(2.5,Sheet1!A1:B3, 2) Sheet2!A1 & A2 cells both display 'Two' Error ==== Copy Sheet2 to new Spreadsheet New Worksheet cell with expected =HLOOKUP(2.5,Sheet1!A1:B3, 2) is fine. However, new Worksheet cell with expected =HLOOKUP(2.5,Sheet1!MyTab, 2) Now has =#N/A What's going wrong, please? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 copy multiple rows to another worksheet | New Users to Excel | |||
| Excel Named Formula Weakly Interacts with a Variable Range on the Worksheet - Re-Visit | Excel Discussion (Misc queries) | |||
| Copy cells from named range | Excel Discussion (Misc queries) | |||
| Copy cells from named range | Excel Discussion (Misc queries) | |||
| copy named range to powerpoint | Excel Worksheet Functions | |||
Linear Mode
