Yes a calculated field should do the trick. It's hard to tell exactly which approached based on your example, but I'll take a stab at it.
Create calculated field that uses an if statement to identify the division, add any additional criteria, and if the entire calculation returns true, return the id (HHID in your case). Just right click on HHID and choose Create Calculated Field. Put in logic similar to this:
IF (put your criteria here) THEN [HHID]
You can then use this calculated field as needed for your application.
Note, sometimes you need to create a couple of calculated fields - and your final calculated field references a different "helper" calculated field to return the outcome you desire.