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))
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))