List should be popup so I can select specific name from that list

Please check attached file you can see some product name in A column , if i type few alphabet in D column,
if if i type amr then list should be popup starting product name with alphabet A then i can select amrut 50 kg from
that list then beside this column for example if i slect product name amrut 50 kg in cell D3 then cell B3 value should be 15
so please give me VBA code for that

i want that if i type few letters like if i type amr then show the list amrut 10 kg, amrut 25 kg and so on which is starting from A then i select amrut 10 kg so i do not need to type amrut 10 kg , it means it save my efforts of typing amrut 10 kg , if i just amr or am and then list populate that showing option like amrut 10 kg, amrut 25 kg, amber 50 kg then i select amrut 10 kg from that list.

Try this :

but it is now allow me to type few letters like amr then list populate matching with amr and showing lit itm like amrut ,amrita, amrenda and so on

@keshavtale, you still use Office 2010?

i am using office 2019

now list populating but i can not select specific name from that list

Thanks now my problem is solved

I want some modification in that VBA code please include C column in that list , please see example i show you in this
attached file , please see cell D6, E6, F6,

Thanks Mr.John Topley now my problem is perfectly solved