Most likeli I should say, can I import from database file into formula

"George" wrote in message
...
Hi,
I have multiple excel files that used range name and data validation,
is there a way to link Sumif or Lookup with external database file and
data validation.