R
rmaris
can i use hlookup to find data in another file?
Bernard said:Yes, but the second file needs to be open.
best wishes
Barb said:You can, but the file will need to be opened in order to update the formulas.