I'd keep an eye out on that LastRow name.

And glad you got it working!

hmmm. Pizza.

Pierre wrote:

Dave,
The sheet is now working fine! Changed the formulas in the cells to
the likes of
=IF(C4="","",(INDIRECT("'"&C$4&"'!$t$20"))). . .instead of the ISERROR
trigger; to return a zerro length string which might have been the
culprit.
Also changed lastrow range to:
=LOOKUP(1,1/(Summary!$B$1:$B$2000<""),ROW(Summary!$B$1:$B$200 0))

Seems that having $C$1:$C$2000 demanded at least 2 tabs be summarized
(in addition to the row headings in column A.

Where would you like that pizza sent?

Pierre

On Apr 11, 9:12 am, Dave Peterson wrote:
You may want to post more details on how it's failing, too.

ps. These Excel newsgroups are overwhelmingly used by people who top post. You
may want to join the club <bg.





Pierre wrote:

On Apr 11, 8:50 am, Dave Peterson wrote:
I'd guess your formulas (in the cells) don't return zero length strings ="".
I'd change the formulas if that's true.

If it's not true, I don't have a guess.

You could modify your formulas in the names:

Summary!Lastcol
=LOOKUP(2,1/(trim(Summary!$1:$1)<""),COLUMN(Summary!$1:$1))

And just a reminder...
when you have sheet names that need surrounding apostrophes, the worksheet level
names would look like:
'Summary 1!LastCol

I'd still fix the offending formulas in the cells, though.

Will keep hammering away at it.

There's always a method.
Pierre

--

Dave Peterson- Hide quoted text -

- Show quoted text -

--

Dave Peterson