Index+Match/ Vlookup help

[Demosassiner]

Hi guys, hoping you can help with this. I currently have two tables, main and input/output below. I need a way to pull the "name" field that corresponds to the "main" code in the main table (which is in column D of input/output table). In other words, a formula to give me column E. Any ideas?

Main:

Row\Col	A​	B​	C​
1​	Name	Code	Number
2​	Microsoft	MSFT	0005
3​	Microsoft Ltd	MICR	0010
4​	Apple Inc	AAPL	0005
5​	Apple (Foreign)	APLE	0010
6​	Apple Co.	APCO	0222
7​	Facebook	FCBK	0050
8​	Facebook Corp	FBBC	0010
9​	Facebook LLC	FACE	0111

<tbody>
</tbody>

io (input and output, where output = main code)

Row\Col	A​	B​	C​	D​	E
1​	Code	Name	Number	Main Code	Main Name
2​	Micro	Microsoft Inc	0010	MICR	Microsoft Ltd
3​	Apple123	Apple	0005	AAPL	Apple Inc
4​	Fbook1	Facebook Inc	0010	FBBC	Facebook Corp

<tbody>
</tbody>

 

[Scott T]

Where sheet1 has your main table.

=INDEX(Sheet1!$A$2:$A$9,MATCH(D2,Sheet1!$B$2:$B$9,0))