Hello,
I have census data where the fields in the attribute table are coded (SF for State) and there is another sheet that has a field with the codes and a field that decodes them (SF | State/County). How do I combine the two sheets to have the labeling show the decoded field name?
Couple of options around the Join functionality.
You could create a temporary join between the two datasets based on the abbreviated field which will connect them, and then you could pick the decoded field as the label field.
Or, you could permanently append (and use to label) the decoded field using the "Join Field" geoprocessing tool, again basing this on the abbreviated field.