Thanks Andy, worked a treat. This will teach me to pay more attention to
detail NA() instead of (NA)

regards

Andy Pope wrote:
Hi,

That would be the function NA() rather than na in brackets.

=IF(INDIRECT("'"&(B1)&"'!c5")="",NA(),INDIRECT("' "&(B1)&"'!c5"))

Cheers
Andy

Hi
I am extracting data from Jan shhet into summary sheet, and from that
[quoted text clipped - 21 lines]

Brian

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200809/1