Substitutions

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.
 
S

Sheeloo

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Need VLOOKUP to Work Two Ways 0
Need help with CountIF function 2
Need help with DGET function 7
Sumproduct between dates 0
Text Extraction (parsing) 3
Displaying Multiple Values without using Macros or ROWS function 4
Excel Wildcard in Excel array formula 0

Top