I was able to point and click to the external worksheet after following your
instructions. But - when I input my data into the entry worksheet, it gives
me a #Value! error. When I researched this earlier, the research indicated
that might happen if the documents were not both saved as .xlsx. I double
checked and both files are saved as .xlsx files. The formulas work fine if
the database is stored within the same worksheet as the input data sheet.
Any ideas? Also, will this work with array formulas?

My formula looks like: =IF('2010 HBR Query Tool
Only.xlsx'!DRUGENTRY="",0,COUNTIF('F:\Query Drug
List-2.xlsx'!DrugList,"*"&'2010 HBR Query Tool Only.xlsx'!DRUGENTRY&"*"))

Any assistance would be greatly appreciated!
--
Lady


"smartin" wrote:

Ah yes, this does not work if you open the workbooks in separate
instances of Excel. You have to open both workbooks in the same
instance. I forgot about that caveat.

Lady Success wrote:
Thank you for the information.... However, it doesn't appear that I can
point and click over to my external worksheet. I thought initially that when
I was trying to do it that it was because I was accessing through the wizard.
But when I just tried it on a blank worksheet, it didn't allow me to do it.
It's like each worksheet is working independently of each other. Am I doing
something wrong - or is it a setting somewhere in Excel? I could have sworn
that I've been able to access cells from other workbooks in the past.