Drop Down List that will alter data on my master tab?

Hello,
I'm going to do my best to explain what it is that I'm looking for so here goes nothing!

I work for a transportation company. We provide our vendors with routing instructions on which truckers to use to get freight to our various warehouses. I also reference it to make sure the vendors are using the correct trucker.

We currently keep this information on word documents. We have 40 vendors so I have 40 word documents. Now that I'm in this new position, I was thinking it would be much easier to have 1 excel. Is it possible to have an excel with a cover sheet tab with a drop down list with the vendors. And depending on which vendor you pick, the information in the cells with the red X change? (On the attached spreadsheet)

The only thing I could think of was writing If statements (If = H1=Vendor1,"Translight Trucking","") on the side, then having a statement in the cell to choose which trucker with =J3&K3&L3 (etc.etc.) but this would take an extremely long time for 40 vendors. Is their an easier way? Is this in the realm of Access?

Thanks in advance!

I am not quite 100% sure that it is that you need to do, can you just post a sample worksheet with the before and after? for example, what is it that you want to happen when you choose vendor 1? where do the things you want to look up come from? you mention Translight truking, but I don't see anything like that on the sheet?

Check the file...click on the company and the carrier should pop up automatically...

Hi and welcome to the forum

You can probably do what you want using a vlookup() functions, but to show you better how to do it, we would need so see the format/layout of the data you want to pull in.

In the mean time, below is a sample of what I am talking about, it may help get you headed in the right direction?

	I	J	K	L	M
2		Info1	Info2	Info3	Info4
3	Vendor 1	a	aa	aaa	aaaa
4	Vendor 2	b	bb	bbb	bbbb
5	Vendor 3	c	cc	ccc	cccc
6	Vendor 4	d	dd	ddd	dddd
7	Vendor 5	e	ee	eee	eeee
8
9	Vendor 3	c	cc	ccc	cccc
10	J9=VLOOKUP($I9,$I$3:$M$7,2,0)

Good morning guys,
Thanks a lot for the support. I don't know why I overlooked VLookUp @_@

This is exactly what I needed. Thanks!!

Happy to help and thanks for the feedback