1-Excel sheet with two columns ABB and NME (abbreviation and full name) 900+ records.
2-Shapefile with Attributes MUNR & MUNL. This attribute has the same abbreviated municipality names as the excel sheet.
What i'm trying to do is create two new attributes (MUNRFull & MUNLFull) on the shapefile that will have the full names.
The statement would be something along the lines of
where ABB = MUNR give me the NME output as MUNRFull.
where ABB = MUNL give me the NME output as MUNLFull.