Hi,

my story: i have 11 workbook for users and one general template, i use vlookup & inderect formula to bring the data to my master file. But this is only works when workbooks are open. I really want to use inderect because i have some conditions behaind (users, position...) when i drag the formula down take this conditions is realy easy to define which work book take to make vlookup. Is there any other strategy to do this with some other formula. I know that you could download add in but this only work for me not is some other users open the master file on his computer.

Thank you very much for help!