commytarter
New Member
- Joined
- Nov 19, 2013
- Messages
- 5
=VLOOKUP(B6,'C:\Documents\Desktop\input files\[=CONCATENATE(TEXT(B6,"mm.dd.yyyy"),".xls")]01.31.2014'!$E$2:$I$7,2,FALSE)
This is the formula I tried and did not succeed.
I'm trying to pull info from external workbooks that are named with dates I have listed in column B of my current workbook.
I thought I could put a concatenate function inside the brackets, where the file name belongs.
I was also hoping to do this for the tab name.
Am I completely off course here? Someone please help me out
This is the formula I tried and did not succeed.
I'm trying to pull info from external workbooks that are named with dates I have listed in column B of my current workbook.
I thought I could put a concatenate function inside the brackets, where the file name belongs.
I was also hoping to do this for the tab name.
Am I completely off course here? Someone please help me out