Hi team.

I am looking to refining my stock sheets in excel.

I have started with indirect lookups so when I pick a catagory of say meat it then presents choices of just meat etc.

However I now wish to split this from the main sheet, which is the stock locations. The purpose for this is so that any price updates could be sent on this sheet to other units without effecting their stock locations sheets.

In essence the stock locations sheet using indirect will be looking at the stock items sheets for its look ups.

What I want to know is realistically is this douable? There will be in excess of 1000 items to look up.

In the stock items sheet as well I was thinking of using the database function so the user could quickly find an item to update. But I am not sure if the user needs to enter the exact item including case sensitivity for it too work? (I have never used database function before)

Thanks for any tips on this, or if I am in a world of dreams let me know!