Project help

I've been assigned a project at my internship where I essentially pull data from one worksheet to another.

The actual dataset is too big to attach, so I put in an example instead. Basically I need to pull the account name, city, state and sales executive from the "Dell Customers" into the "Tech Data Customers" tab using the TD Cust# that's on the TD Customer tab.

I've used [=INDEX('Dell Customers'!C8:$C$38097,MATCH('Tech Data Customers'!A1,'Dell Customers'!G8:$G$38097,0))] and while it works for someone, it doesn't for most of it.

Any help will be appreciated.