Would like to ask for help on what I'm currently working.
Sales_Conso.xlsm is my consolidating workbook. Range D8 to last column, contains the file names of the workbook where my table array will be.
What I wanted to achieve is:
If range D11 to last row is blank, it will open the workbook specified based on the file name on D8 and will apply the vlookup formula.
Lookup_Value = Sales_Conso.xlsm range B8 to last row
Table_Array = Filename on D8 to last column, range B7 to last cell with value
Col_index_num = 10
I've attached the sample files for everyone's reference.