Forum Discussion
Searchable Drop-down list for multiple cells sourcing from another worksheet in Excel.
Hi Experts,
I want to access the master database using “Item Code” in Daily Stock Movement Register Sheet. I have used the basic drop-down list using data validation function but due to length of the list, it is getting annoyed to choose the right product.
I saw some experts’ opinion in the web but it is useful for a sheet where we stored the database.
Advance thanking you for your opinion.
4 Replies
- Hi,
This was very useful until the new updated office 365 which seems not to allow the formula to calculate and I have tried using the new dynamic array formulas of transpose, sort, filter, and isnumber but not working for multiple sheets or referencing other sheets!!!
Please any helpful suggestions???The idea is here (2) Searchable Drop Down List in Excel (Very Easy with FILTER Function) - YouTube, not sure what could be wrong with reference on another sheet.
