Hi everyone. New to the forum. Thanks in advance for your assistance.

I have stock price data downloaded in individual .xls files titled by Symbol (just 2 columns - Date & Close). I would like to be able to INDEX MATCH or VLOOKUP closing prices on a certain date using a file path, with the path capable of being adapted when I type in a new symbol and/or date. I have attached the layout I had in mind. I was able to use an index formula to grab the data, however with the enormous amount of stocks/mutual funds out there, it seems improbable to type the file name into every formula. If someone feels that vba would be more productive, I'm open to it (although my experience is limited). Thanks again.

Stockdata.xlsx