I want to copy value from one worksheet to another sheet within same workbook for two column.
I want the first or second column to be searchable means dropdown with dynamic suggestion as am typing based upon the value another column must be filled.

Clear understanding purpose:

For example consider a workbook with sheet 1 and 2.
In sheet 2 it has content of

11 1760 3097600 1760
12 3520 6195200 1760
13 5280 9292800 1760
43 7040 12390400 1760
5 8800 15488000 1760
6 10560 18585600 1760


In sheet1 when I type in column i need to show suggestion as 11,12,13 when typed 1

After chosing as 11 it complete neighbor column as 1760 value automatically

NO Value
11 1760