Try create Price Offer table

[Fresh87]

Hi,

sorry for my bad English, but I am from Slovakia

I try create table for make price offers for my small company.

I have Two sheets in one sheet I have prices of material and work price like that.

Spec	Price Mat.	Price Mont.
Cable	1,39	2,59
Socket	1,99	5,59
Cable 8pin.	1,99	5,59

And In my second sheet is price offer. This table has more Columns with functions etc.

But my problem is, I need if I start in my second sheets (Column - Spec) start writing Cab .. I need auto fill this text from first sheet.

For example I start write "Cab" and excel give me 2 opinions for click "Cable 8pin." and "Cable".

Is it possible ?

BIG THANK YOU for response.

[JohnTopley]

Please see the yellow banner at top of page on how to attach a sample workbook.

[Fresh87]

done, and now can you help me please ?

[AliGW]

Have a look here: https://www.xelplus.com/searchable-drop-down-list/