Lead Letter to be come when typing (Searchable Drop Down List)

%3CLINGO-SUB%20id%3D%22lingo-sub-3293255%22%20slang%3D%22en-US%22%3ELead%20Letter%20to%20be%20come%20when%20typing%20(Searchable%20Drop%20Down%20List)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3293255%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Every%20One%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20table%20A%20and%20Table%20B%20with%20me.%26nbsp%3B%3C%2FP%3E%3CP%3ETable%20B%20is%20master%20list%20of%20items%20with%20prices.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20Table%20A%20I%20need%20to%20put%20input%20item%20name%2C%20for%20that%20it%20will%20be%20difficult%20to%20enter%20full%20name%20every%20time%20from%20Table%20B.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20that%20I%20need%20to%20use%20a%20data%20validation%20trick%20to%20enter%20the%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20need%20is%2C%20whenever%20we%20enter%20first%20letter%2C%20in%20searchable%20area%2C%20suggested%20list%20of%20items%20from%20Table%20should%20appear.%20The%20Data%20entry%20man%20can%20choose%20the%20item%20to%20proceed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20VBA%20of%20formula%20for%20this%3F%3F%3F%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Sameer_Kuppanath_Sultan_0-1650800622692.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F366352iE2433E9277BAD0E9%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Sameer_Kuppanath_Sultan_0-1650800622692.png%22%20alt%3D%22Sameer_Kuppanath_Sultan_0-1650800622692.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3293255%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3297451%22%20slang%3D%22en-US%22%3ERe%3A%20Lead%20Letter%20to%20be%20come%20when%20typing%20(Searchable%20Drop%20Down%20List)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3297451%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1344074%22%20target%3D%22_blank%22%3E%40Cangkir%3C%2FA%3E%20Thank%20You.%3CBR%20%2F%3E%3CBR%20%2F%3EBut%20I%20need%20the%20same%20thing%20in%20Cell%20while%20start%20typing%20letters%20in%20the%20same%20cell%2C%20not%20with%20User%20Forms.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThat%20is%2C%20Instead%20of%20Userform%2C%20I%20need%20to%20use%20it%20in%20Cells%20itself.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3293583%22%20slang%3D%22en-US%22%3ERe%3A%20Lead%20Letter%20to%20be%20come%20when%20typing%20(Searchable%20Drop%20Down%20List)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3293583%22%20slang%3D%22en-US%22%3EYou%20can%20try%20using%20a%20free%20Excel%20add-in%20%22Search%20deList%22.%20You%20can%20find%20it%20here%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.mrexcel.com%2Fboard%2Fthreads%2Fi-created-an-excel-add-in-called-search-delist-to-create-searchable-data-validation.1189466%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.mrexcel.com%2Fboard%2Fthreads%2Fi-created-an-excel-add-in-called-search-delist-to-create-searchable-data-validation.1189466%2F%3C%2FA%3E%3CBR%20%2F%3EIt%20gives%20you%20a%20unique%2C%20sorted%20%26amp%3B%20non-empty%20list%2C%20and%20you%20can%20search%20by%20multiple%20keywords.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3293566%22%20slang%3D%22en-US%22%3ERe%3A%20Lead%20Letter%20to%20be%20come%20when%20typing%20(Searchable%20Drop%20Down%20List)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3293566%22%20slang%3D%22en-US%22%3EAlso%2C%20I%20want%20to%20allocate%20this%20job%20to%20my%20subordinate%2C%20they%20dont%20have%20any%20latest%20version%20of%20MS%20Office.%3CBR%20%2F%3EBecause%20their%20job%20is%20limited%20to%20Data%20Entry%20Only.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3293565%22%20slang%3D%22en-US%22%3ERe%3A%20Lead%20Letter%20to%20be%20come%20when%20typing%20(Searchable%20Drop%20Down%20List)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3293565%22%20slang%3D%22en-US%22%3EI%20AM%20USING%20MICROSOFT%20365.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3293300%22%20slang%3D%22en-US%22%3ERe%3A%20Lead%20Letter%20to%20be%20come%20when%20typing%20(Searchable%20Drop%20Down%20List)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3293300%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F420510%22%20target%3D%22_blank%22%3E%40Sameer_Kuppanath_Sultan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20you%20looking%20for%20something%20like%20this%3F%26nbsp%3B%20This%20feature%20is%20currently%20available%20to%20Office%20insiders%20Beta%20channel.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Patrick2788_0-1650811522564.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F366360i22D0D04D44A62286%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Patrick2788_0-1650811522564.png%22%20alt%3D%22Patrick2788_0-1650811522564.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Frequent Contributor

Hi Every One

 

I have table A and Table B with me. 

Table B is master list of items with prices. 

 

In Table A I need to put input item name, for that it will be difficult to enter full name every time from Table B.

 

So that I need to use a data validation trick to enter the data.

 

What I need is, whenever we enter first letter, in searchable area, suggested list of items from Table should appear. The Data entry man can choose the item to proceed.

 

Is there any VBA of formula for this???? 

 

Sameer_Kuppanath_Sultan_0-1650800622692.png

 

5 Replies

@Sameer_Kuppanath_Sultan 

Are you looking for something like this?  This feature is currently available to Office insiders Beta channel.

Patrick2788_0-1650811522564.png

 

I AM USING MICROSOFT 365.
Also, I want to allocate this job to my subordinate, they dont have any latest version of MS Office.
Because their job is limited to Data Entry Only.
You can try using a free Excel add-in "Search deList". You can find it here:
https://www.mrexcel.com/board/threads/i-created-an-excel-add-in-called-search-delist-to-create-searc...
It gives you a unique, sorted & non-empty list, and you can search by multiple keywords.
@Cangkir Thank You.

But I need the same thing in Cell while start typing letters in the same cell, not with User Forms.


That is, Instead of Userform, I need to use it in Cells itself.