Not sure if I need an array here -- never used one but it sounds appropriate. I want each cell in column D to populate with the appropriate abbreviation of the building name in Column B and the Office number in Column C, thus creating an "Office Code" for each building and office number. There is a "key" or "legend" of these building abbreviations found in columns E and F.

For example, John Doe (Column A) works in Johns Hall (column B). His Office number is "1" as found in Column C. Column D should populate with "JHN-1" which it has determined to be the appropriate combination of both the building abbreviation and the office number.

The list of building names will grow, however. The real list is currently about 60 long so I don't want a nested IF statement that includes 60 building names and counting. Any good solutions??

The actual sheet is a CSV file but that file was deemed invalid to post by excelforum.com.

Thanks,

JoeTempExample.xlsxTempExample.xlsx