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