I want to use Importrange to get data from excel file2 to file1,i set the range_string from file2,but the formula take the data from file1.
i trust the link i used is fiel2.
file have 3 or 4 sheet file.
in file2 sheet1【 I7】 data is 【13,135,163】
but the formula get data from 【file1】【 I7】 【111】。
If i set range_string in [“I7”] it well become [#Name/?].
how to use Importrange to get data from another excel files