I have a repair database that when I put in "Waiting for Parts" status (Column I), I will look up the repair ID (Column C) in [Parts Worksheet], and look if there is a match. If there is a match, it puts the same ID in Column A. This lets me know that I have a part inputted for the repair...