I have two sheets of with vehicles that are working days of the week.

Sheet 1(Log On):

Vehicle Day P/U Rec'd?
HN57 OFK Monday
HN57 OFK Wednesday
BX07 MKL Monday
LF08 YJO Tuesday
NG09 MDV Tuesday

Sheet 2 (Power Up):

Vehicle Driver
HX56 MYH Monday
HX56 MYH Saturday
HN57 OFK Monday
HN57 OFK Tuesday

I want to perform a vlookup that returns "OK" to the "P/U rec'd" colomn in sheet 1 only if the vehicle powers up on the correct day. i.e, in the above example, the only return value should be on HN57 OFK, Monday.

How can I go about doing this?