Why does the second file need to be open?

Bernard Liengme wrote:

Yes, but the second file needs to be open.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"rmaris" wrote in message
...
can i use hlookup to find data in another file?

--

Dave Peterson