Index Match across multiple sheets

[gdamato]

Hello all, I've read other threads and can't figure out why this isn't working...
Data!B2 has a company name,
Sheet1 has Company names (column E) and Seller names (column D)
I want to look at Data!B2 (company name), find the company name on Sheet1! (column E) and then populate the corresponding seller name from Sheet1! (column D)


=INDEX(Sheet1!D2:D3445,MATCH(Data!B2,Sheet1!E2:E3445,0))

 

[gdamato]

Disregard, user error, lol

 

[Fluff]

In what way isn't it working?