Hi, first post.

I'm trying to create a log book in excel for my company. The log book will have various columns (A-Key No, B-Apartment No, C-Sets given, D-Day logged out, E-Guest name, F-Day logged in, G-Sets Back).

Column C & G will use a data list of options (Set A, Set B, Set C, Set A+B, Set A+C, Set B+C)

I want to prevent keys going 'missing' by making excel prevent staff from logging keys out by having excel see that the apartment keys haven't been logged in (column F) is blank.

So in my rows I may have lots or apartment keys logged out from row 2 to 30 for example and then on row 31 if someone is trying to log out a set of keys that haven't been recorded as back in excel will prevent the user from completing the required information in that row.

I know how to use Vlook up but I'm not sure how I can provide a logical test to provide a warning message that I could then link in with conditional formatting???