If C2=X then vlookup Range1 or if C2=Y then vlookup Range2

If C2 = "Company" then lookup range of Company!A:B then match Data! column A to Company! column A and display the value from Company! column B.
If C2 = "Owner" then lookup range of Owner!A:B then match Data! column A to Owner! column A and display the value from Owner! column B.


Data:

	A	B	C	D
	Employee #	Name	Type	Vehicle #
1	AB123	Andrew Baker	Owner	*FORMULA HERE*
2	CD456	Chris Davidson	Company	*FORMULA HERE*
3	EF789	Eric Ferguson	Company	*FORMULA HERE*
4	GH123	Gary Harper	Owner	*FORMULA HERE*

Company:

	A	B
	Employee #	Vehicle #
1	CD456	1111
2	EF789	2222

Owner:

	A	B
	Employee #	Vehicle #
1	AB123	0000
2	GH123	3333

@ConneXionLost Thank you that did it!