I have a question.
The filename in an hlookup function seems to never accept a dynamic value, like a cell value. For example, if I try to use the following function:
and I have a whole bunch of files in the folder named excel1, excel2, excel3, excel4 etc, is there anyway to open one of these files by simply putting a "1" or "2" etc into a specific cell? So instead of putting 'excel1.xlsx' into the function, you would use a value like a cell value that can be changed by the user?Please Login or Register to view this content.
Thank you in advance for any help. I can't seem to figure out how to do this.
Bookmarks