Tracey Hartley
New Member
- Joined
- Nov 20, 2020
- Messages
- 4
- Office Version
- 2013
- Platform
- Windows
Hi all. I've checked out previous threads and can see that this issue has been raised before, but I've tried the suggested solutions and it makes no difference - hoping someone can help?
=IFERROR(VLOOKUP([@Name],'M:\InspireAll Generic and Admin\Staff Admin\Audit\All Staff Audit _Fam Centre.xlsx'!AllStaff_Table[#All],11,FALSE),"Not Found")
Works beautifully if the All Staff Audit_Fam Centre file is open, but if I close it then make a change in the destination worksheet, it suddenly changes the cell back to "Not Found" - what am I doing wrong?!
=IFERROR(VLOOKUP([@Name],'M:\InspireAll Generic and Admin\Staff Admin\Audit\All Staff Audit _Fam Centre.xlsx'!AllStaff_Table[#All],11,FALSE),"Not Found")
Works beautifully if the All Staff Audit_Fam Centre file is open, but if I close it then make a change in the destination worksheet, it suddenly changes the cell back to "Not Found" - what am I doing wrong?!