Compare and update cells found with VLOOKUP?

[Mjones]

Hello!

This is my first post on this forum, so hello everyone!

Im trying to create a workbook to track jobs my co-workers and I are working on. (i've attached what i have so far)

I used VLOOKUP to populate the fields in blue based on the number entered in the green field (there are a few test entries now, but there will be 500-1000 when in use)

What i would like to find a way to do is if the field returned with VLOOKUP is blank allow my users to enter information in the yellow fields and then have it update my sheet with the new entered data. If this somthing that can be done? Or is there another way i could go about doing this all together?

Any help would be greatly appriciated!

Thanks!

~Mark