| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Substitutions
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Substitutions
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
