Autofilling names in a separate sheet based on non constant values in a separate column

[illinimarine7]

Ok, this may sound a little confusing because I suck at explaining things, but here is what I'm trying to do:

I have 3 sheets, one is a schedule of employees working for the day, the second is a sheet with timeframes that vehicles become available. When I fill values into these columns, it auto populates the schedule with vehicle numbers next to their name.

Ok, here is the tricky part, on the third sheet I have a list of vehicles with the vehicle number. What I need to do, is match the vehicle number to the name of the employee. Say employee John Doe starts at 1400. He has vehicle 14 autopopulated in his vehicle cell on the schedule. Now I need his name to automatically fill the vehicle 14 cell on the third page vehicle list.

Thanks, if you need any clarification I will do my best to clear it up. I know that can probably sound very confusing.

 

[bschwartz]

Would something like this work?

Excel 2010
	A	B
1	Employee	Vehicle (auto-populated)
2	Joe	Vehicle 4
3	David	Vehicle 23
4	Kyle	Vehicle 17
5	Lucy	Vehicle 20
6	John Doe	Vehicle 14
7	Harry	Vehicle 22
8	Jim	Vehicle 10
Employees

Excel 2010
	A	B
1	Vehicle Inventory	Employee Assignment
2	Vehicle 1
3	Vehicle 2
4	Vehicle 3
5	Vehicle 4	Joe
6	Vehicle 5
7	Vehicle 6
8	Vehicle 7
9	Vehicle 8
10	Vehicle 9
11	Vehicle 10	Jim
12	Vehicle 11
13	Vehicle 12
14	Vehicle 13
15	Vehicle 14	John Doe
16	Vehicle 15
17	Vehicle 16
18	Vehicle 17	Kyle
19	Vehicle 18
20	Vehicle 19
21	Vehicle 20	Lucy
22	Vehicle 21
23	Vehicle 22	Harry
24	Vehicle 23	David
Vehicle Number

Cell Formulas
Range	Formula
B2	=IFERROR(INDEX(Employees!$A$2:$A$8,MATCH(A2,Employees!$B$2:$B$8,0)),"")