Dropdown with suggestion based upon another sheet within workbook

[159753]

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

[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl63, width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl63"]11[/TD]
[TD="class: xl63"]1760[/TD]
[TD="class: xl63"]3097600[/TD]
[TD="class: xl63"]1760[/TD]
[/TR]
[TR]
[TD="class: xl63"]12[/TD]
[TD="class: xl63"]3520[/TD]
[TD="class: xl63"]6195200[/TD]
[TD="class: xl63"]1760[/TD]
[/TR]
[TR]
[TD="class: xl63"]13[/TD]
[TD="class: xl63"]5280[/TD]
[TD="class: xl63"]9292800[/TD]
[TD="class: xl63"]1760[/TD]
[/TR]
[TR]
[TD="class: xl63"]43[/TD]
[TD="class: xl63"]7040[/TD]
[TD="class: xl63"]12390400[/TD]
[TD="class: xl63"]1760[/TD]
[/TR]
[TR]
[TD="class: xl63"]5[/TD]
[TD="class: xl63"]8800[/TD]
[TD="class: xl63"]15488000[/TD]
[TD="class: xl63"]1760[/TD]
[/TR]
[TR]
[TD="class: xl63"]6[/TD]
[TD="class: xl63"]10560[/TD]
[TD="class: xl63"]18585600[/TD]
[TD="class: xl63"]1760[/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[/TR]
</tbody>[/TABLE]


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

After typing as 11 it complete neighbor column as 1760 value

NO Value
11 1760

 

[a_songaila]

Hello, I think you can use VLOOKUP with dropdown cell Formula for this.

So lest say you create Dropdown cell in A1, in B1 you insert formula =VLOOKUP(A1,!Sheet2,2,FALSE), where it says !Sheet2 in vlookup just insert a table from sheet 2 there.

 

[159753]

Thanks for your support Bro

 

[159753]

Other links:https://www.excelforum.com/excel-for...ml#post4708904
Other Links:https://www.excelguru.ca/forums/showthread.php?8122-dynamic-suggestion-with-auto-populate-neighbor-cell