On the attached, on worksheet "Vehicle summary" , in cell B4 (Column entitled EX61XUS i.e. the vehicle registration), I want excel to look at worksheets "Fred" & "Joe" and return with the driver that was driving EX61XUS on 01/09/11. (Fred Bloggs)
The driver name should come from cell B4 on tabs "Fred" (Fred Bloggs) or "Joe" (Joe Bloggs).
In the example shown, on tab "Vehicle summary", cell B4 should equal "Fred Bloggs" and cell B5 should equal "Joe Bloggs".
I need this to be able to look accross approx 50 worksheets when I populate all vehicles/drivers.
Does anyone know if this is possbile?
Thanks in advance.
Bookmarks