Two columns

[the_sea]

Hello, I have to populate two columns: B with company name and C with company's code. So I made a range in another sheet with company names and codes and called the range ABC.
Then I made an ActiveX ComboBox with this settings:

BoundColumn 2
ColumnCount 2
ListFillRange ABC
TextColumn 1
Mostly I tried to guess this values.

The good part is that, if I type Abc, combo knows that I am reffering to company Abcdef and autocomplete full name, but that's the only good part.

Less good parts: it doesn't allow me to copy the name and the code, even if it displays it if I click the combo's down arrow. I need the code, too.
Second, instead of typing names from ComboBox, then copy/paste where I need, isn't possible to type directly in empty cell B11 - for example Abc, and autocomplete Abcdef in B11 and 123 in C11? Then, for B12, next company name and code? Do I really have to copy/paste?

I tried with a UserForm, didn't work.
If somebody wants to help me, I am opened to try ComboBox, UserForm or VBA codes.
Sorry for language mistakes, I am from Romania and learning a lot. Thank you!

1	Abcdef	123	Chips	12345	636		8700	11/17/2020
2	Ghijkl	456	Chips	12345	410		8701	11/17/2020
3	Mnopqr	789	Chips	12345	413		8702	11/17/2020
4	Stuvwx	135	Chips	12345	520		8703	11/17/2020
5	Yz1234	246	Chips	12345	305		8704	11/18/2020
6	Mnopqr	789	Chips	12345	370		8705	11/18/2020
7	Abcdef	123	Chips	12345	511		8706	11/18/2020
8	Mnopqr	789	Chips	12345	532		8707	11/18/2020					In Name Manager, in another sheet
9	Ghijkl	456	Chips	12345	400		8708	11/19/2020					range from A1 to B5 called ABC:
10	Abcdef	123	Chips	12345	540		8709	11/19/2020
11			Chips	12345						ComboBox1			Abcdef	123
12			Chips	12345						BoundColumn	2		Ghijkl	456
					4637​					ColumnCount	2		Mnopqr	789
										ListFillRange	ABC		Stuvwx	135
										TextColumn	1		Yz1234	246

 

[the_sea]

I win. It was a big problem because I searched the answers day and night, for months, questioning myself if I am not able to apply a vlookup formula.
Evrika!
Formulas found on Google were right, but not for me.
When you install Windows, it asks you about Regional and language settings. I opted for English language for my computer, but for East Europe, Romania as setting for Region, because English and Romania have different ways for date/time, decimals etc. Microsoft make and Windows, and Office, so the Office automaticaly take system information.
All I had to to was to replace the comma "," with ";" . Yours decimals are not mine... Pe romaneste: inlocuiti virgula din formule cu ";" punct si virgula