Use Index with Match forumula to get what you want. I can write it for you if
you paste sample data

"Amco" wrote:

Column B has Department Names Column C has the department codes, the
department codes are the headings of columns F-H. What formula can I set that
will read the previous column and choose the applicable heading codes in
coulumns F-H.