Excel 2002 SP3 Copy Worksheet with another sheet named range now #

B

Brewmanz

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?
 

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

Similar Threads

Development combinations with exclusion of columns 0
Match Copy/Paste Macro almost there 0
COUNTIF, Sorting, Two Sheets 0
Sorting and COUNTIF 6
COUNTIF, Sorting, on Two Sheets 1
Countif, Sorting => Two Sheets 0
Offset in another sheet 2
Fill formula down for cells 74 rows apart 3

Top