Searchable Drop-down list for multiple cells sourcing from another worksheet in Excel.

%3CLINGO-SUB%20id%3D%22lingo-sub-1053017%22%20slang%3D%22en-US%22%3ESearchable%20Drop-down%20list%20for%20multiple%20cells%20sourcing%20from%20another%20worksheet%20in%20Excel.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1053017%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Experts%2C%3C%2FP%3E%3CP%3EI%20want%20to%20access%20the%20master%20database%20using%20%E2%80%9C%3CSTRONG%3EItem%20Code%3C%2FSTRONG%3E%E2%80%9D%20in%20%3CSTRONG%3EDaily%20Stock%20Movement%20Register%3C%2FSTRONG%3E%20Sheet.%20I%20have%20used%20the%20basic%20drop-down%20list%20using%20data%20validation%20function%20but%20due%20to%20length%20of%20the%20list%2C%20it%20is%20getting%20annoyed%20to%20choose%20the%20right%20product.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20saw%20some%20experts%E2%80%99%20opinion%20in%20the%20web%20but%20it%20is%20useful%20for%20a%20sheet%20where%20we%20stored%20the%20database.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAdvance%20thanking%20you%20for%20your%20opinion.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1053017%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1053204%22%20slang%3D%22en-US%22%3ERe%3A%20Searchable%20Drop-down%20list%20for%20multiple%20cells%20sourcing%20from%20another%20worksheet%20in%20Excel.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1053204%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F480235%22%20target%3D%22_blank%22%3E%40Sivahari%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20idea%20is%2C%20for%20example%2C%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.pk-anexcelexpert.com%2Fsearchable-drop-down-list%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.pk-anexcelexpert.com%2Fsearchable-drop-down-list%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2572817%22%20slang%3D%22en-US%22%3ERe%3A%20Searchable%20Drop-down%20list%20for%20multiple%20cells%20sourcing%20from%20another%20worksheet%20in%20Excel.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2572817%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3EThis%20was%20very%20useful%20until%20the%20new%20updated%20office%20365%20which%20seems%20not%20to%20allow%20the%20formula%20to%20calculate%20and%20I%20have%20tried%20using%20the%20new%20dynamic%20array%20formulas%20of%20transpose%2C%20sort%2C%20filter%2C%20and%20isnumber%20but%20not%20working%20for%20multiple%20sheets%20or%20referencing%20other%20sheets!!!%3CBR%20%2F%3EPlease%20any%20helpful%20suggestions%3F%3F%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2574440%22%20slang%3D%22en-US%22%3ERe%3A%20Searchable%20Drop-down%20list%20for%20multiple%20cells%20sourcing%20from%20another%20worksheet%20in%20Excel.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2574440%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F528567%22%20target%3D%22_blank%22%3E%40ituryu%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20idea%20is%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DZ-h2UER3b_0%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E(2)%20Searchable%20Drop%20Down%20List%20in%20Excel%20(Very%20Easy%20with%20FILTER%20Function)%20-%20YouTube%3C%2FA%3E%2C%20not%20sure%20what%20could%20be%20wrong%20with%20reference%20on%20another%20sheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2581040%22%20slang%3D%22en-US%22%3ERe%3A%20Searchable%20Drop-down%20list%20for%20multiple%20cells%20sourcing%20from%20another%20worksheet%20in%20Excel.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2581040%22%20slang%3D%22en-US%22%3EI%20found%20out%20that%20I%20didn't%20need%20to%20go%20into%20the%20Macros%20section%20and%20type%20%22application.%20calculate%22%20again.%20Problem%20solved.%3CBR%20%2F%3ECheers%20and%20thank%20you%20for%20always%20trying%20to%20help.%3CBR%20%2F%3EGod%20Bless%20you.%3C%2FLINGO-BODY%3E
Occasional Visitor

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???
I found out that I didn't need to go into the Macros section and type "application. calculate" again. Problem solved.
Cheers and thank you for always trying to help.
God Bless you.