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

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

<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>

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