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.