Need Triggering event with cells calculate resulting in mess

[Lt. Krul]

My Timesheet contains rows for Project Codes and Hours spent during the week with the end cell calculating the hours for that project.
I need a way to Keep users from entering hours on a row (which results in a calculated last row with value <>0)without selecting a Jobcode first. A message would pop up warning "Any time spent must have an associated Job code. Please enter Job code."

Any Help here would be appreciated.

 

[Lt. Krul]

Wow, that was fast and It worked Great...

I was indeed able to use the Vlookup function to return the values I wanted. I also experimented and discovered that I could use the "&" symbol to link two VLOOKUP functions to return columns 2 & 3 to the same B1 cell.

I had to modify my Data Verification for the A1 cell (appearantly it dosent like multiple columns in the named range) so I simply created another named range.

Thanks again to all.