I want to retrieve a value from a specific external workbook, the directory where the workbooks are going to be saved will be written in cell A1 and the name of the file will be un A2, if I want to get the value from the workbook in cell F6.
What formula should I use? Concatenating just returns the directory, file, and F6 instead of the value.
Thank you!
What formula should I use? Concatenating just returns the directory, file, and F6 instead of the value.
Thank you!