Hi,
I need to find out how to generate data, say, in column C based on data keyed in columns A and B.
Column A includes regions: Nashville, Chattanooga, Knoxville
Column B includes departments: Administration, Family Care, Quality
Example of what I would like:
A B C
1 Nashville Family Care NF (or N2)
2 Nashville Quality NQ (N3)
3 Knoxville Administration KA
4 Knoxville Quality KQ
5 Chattanooga Quality CQ
Would this be a concatenated field (if so, how?) or IF or Lookup?
Thank you!!!!
Bookmarks