Substitutions

  • Thread starter Thread starter Amco
  • Start date Start date
A

Amco

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.
 
Use Index with Match forumula to get what you want. I can write it for you if
you paste sample data
 
Back
Top