can i use hlookup to find data in another file
 

can i use hlookup to find data in another file?

can i use hlookup to find data in another file
 

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?

can i use hlookup to find data in another file
 

You can, but the file will need to be opened in order to update the formulas.

"rmaris" wrote:

can i use hlookup to find data in another file?

can i use hlookup to find data in another file
 

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

can i use hlookup to find data in another file
 

You sure?

Barb Reinhardt wrote:

You can, but the file will need to be opened in order to update the formulas.

"rmaris" wrote:

can i use hlookup to find data in another file?

--

Dave Peterson