Hello All,

I was hoping someone might be able to help me. I have a few spreadsheets that I want to use VLookups on, basically to look up a project code in another spreadsheet (Column A1:A999999) and copy across the project name and other details into the spreadsheet.

So it would be like

Status spreadsheet VLookups the Project Spreadsheet.

But the problem is that when I do a VLookup on another spreadsheet it seems to make the Project Spreadsheet Read Only. Is there any way i can open the spreadsheet read only by the VLookup formula so that other people can continue to open it and use it without it being made read only due to the exclusive access provided by the VLookup.

I would need to include an IF statement, so that if the project ID includes F then VLookup ProjectSpreadsheet B, else VLookup ProjectSpreadsheetA. But am stuck on the exclusive access.

Thanks for your help!