Matching Fields between tables to populate third field

I have a field in two of my tables entitled "Group ID". When these fields match, I want them to populate a third field called "Household ID". Is this possible? I've tried formulas and other ideas, bu...