Vlookup in Powerpivot

[cajste]

Hi!

I have to tables, one voyage table containing all the voyages our different trucks has done with departure and arrival time for each voyage and the other table containing GPS data taken every 64 seconds for each truck, example below.

What I want to know is what ListItemID each GPS point is refereable to? I would like to have the In excel I would use a vlookup but how do I do that in powerpivot?

Brgds,
Caj

ListItemID	Vehicle	RealDeparture	RealArrival
9177abe0-9c38-4baa-af2f-7cc6eb063ba9	142.001	2012-12-01 13:56	2012-12-01 14:16
ab3c3ae7-eeff-4600-a3fb-173e4cfef706	142.001	2012-12-01 14:14	2012-12-02 00:43
4f41977e-6f19-4efc-ac46-3946c3bdfa17	142.001	2012-12-02 04:38	2012-12-02 06:44
bf05b049-6805-4fc4-b909-ffa91e08ca36	142.001	2012-12-02 17:35	2012-12-02 17:48
bf05b049-6805-4fc4-b909-ffa91e08ca37	142.002	2012-12-02 19:35	2012-12-02 23:48

<tbody>
</tbody><colgroup><col><col><col><col></colgroup>

Vehicle	GPS TIME
142.001	2012-12-01 14:02:21
142.001	2012-12-01 14:02:25
142.001	2012-12-01 14:02:29
142.001	2012-12-01 14:02:33
142.001	2012-12-01 14:02:37
142.001	2012-12-01 14:02:41
142.001	2012-12-01 14:02:45
142.001	2012-12-01 14:02:49
142.001	2012-12-01 14:02:53
142.001	2012-12-01 14:02:57
142.001	2012-12-01 14:03:01
142.001	2012-12-01 14:03:05
142.001	2012-12-01 14:03:09
142.001	2012-12-01 14:03:13
142.001	2012-12-01 14:03:17
142.001	2012-12-01 14:03:21
142.001	2012-12-01 14:03:25
142.001	2012-12-01 14:03:29

<tbody>
</tbody><colgroup><col><col></colgroup>