Hi all, You lots were ridiculously helpful with my last question and hopefully you can help me with this one!
I want to be able to have the formula =IFERROR(VLOOKUP(A2,"AGENT"!A:A,1,0,"") to work over seperate workbooks. I have it working for one workbook with multiple sheets in it currently. However the file seems to crash whenever i try to share it (so that all the colleagues can access the worksheet in their name). I can only assume that the file is too taxing for the system?
I want to be able to have the formula =IFERROR(VLOOKUP(A2,"AGENT"!A:A,1,0,"") to work over seperate workbooks. I have it working for one workbook with multiple sheets in it currently. However the file seems to crash whenever i try to share it (so that all the colleagues can access the worksheet in their name). I can only assume that the file is too taxing for the system?