dynamic suggestion with auto populate neighbor cell

[123789456]

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

[jeffreybrown]

Your question is two parts.

The first, not so easy in Excel without VBA. Google "Filter as you Type" and you'll see some suggestions.

The second, look at Vlookup

[123789456]

Firstly thanks for your rapid support.

If it work in VBA is also fine for me,bro.

Can you provide VBA code for that since i don't know how to code it.

[123789456]

Other Links:https://www.mrexcel.com/forum/excel-...-workbook.html

Other Links:https://www.excelguru.ca/forums/show...-neighbor-cell

[jeffreybrown]

Can you provide VBA code for that since i don't know how to code it.

I understand you don't know how to code it, but there are plenty of tutorials on-line for you to research.

Since I don't know your workbook setup, I don't know whether you expect to use this with multiple drop down boxes or just one.

Here's one place to start