Jan 31 2022 06:14 PM
I try to better explain the problem I have already posted from which I had very good help and learned few thinghs so let me start with a thank you
I have a list of files name in a drop list (source is column AU) and files location is written just as a sample reference.
I would like to be able to select a file from the drop list and have the value in cell L10 of the selected file to be reported in the column “value” of the table
I tried using the indirect formula combine with INDEX and MATCH but I have learned from previus post that is not working if the target file is not opened. For my pourpose I defenetly nedd the file not to be open. Im scared that using VBA will be too advanced for my rookie skils but if not possible with just formula I will consider using VBA and improove my skill
Thank you for your time
Feb 01 2022 02:23 AM
SolutionI'm afraid that what you ask is not possible without VBA.
Feb 01 2022 03:05 PM
Feb 01 2022 02:23 AM
Solution