I'm going to show you a no-code, simple way to create a Filtered Lookup Column in SharePoint which will work with any version of SharePoint.
There is a solution on Codeplex which creates a custom Site Column to handle this but as far as I know it's not compatible with SharePoint 2013 and had a few quirks in other versions based on the user comments. There are also some documented ways to accomplish this with jQuery and custom c# code. However, I have found for most cases this is an effective, fast, no-code way to accomplish the same thing. This solution works based on the fact that a Lookup Column in SharePoint will not return blank values.
- Create a new Calculated Column in your source list (Job List) that your Lookup Column will be reading from.
- Give the column whatever name you'd like, I'll call mine "ActiveTitle"
- Insert your condition into the condition box. In my case I will be using an "If" condition to check the Job Status. If it's Active I want to display the Title of the item and if it's anything else, make it blank (see screen shot below).
- Here is a good resource for examples on different conditions for calculated columns in SharePoint: http://msdn.microsoft.com/en-us/library/bb862071(v=office.14).aspx)