Spreadsheet: 878107d1725081547-formula-for-intersection-of-rows-and-columns-extend-excel-8-365-wip-aligw
Sheet: Sheet1

Modules(columns) | T/F |  |  |  |  |  |  |  |  | Modules(columns) | Analytics | Systems Analyst | Business Analyst | Development | Product Manager | Department Manager | Team Leader
d3 | FALSE |  |  |  |  |  |  |  |  | d3 | 1 | 2 | 3 | 4 | 5 | 6 | 7
Administration | FALSE |  |  |  |  |  |  |  |  | Administration | 1 | 2 | 3 | 4 | 5 | 6 | 7
Obstetrics | FALSE |  |  | Fill in your expected results here (manually). |  |  |  |  |  | Obstetrics | 1 | 2 | 3 | 4 | 5 | 6 | 7
Pharmacy | FALSE |  | BARS.STAR |  |  |  |  |  |  | Pharmacy | 1 | 2 | 3 | 4 | 5 | 6 | 7
BARS - Healthcare Monitoring | TRUE |  | Vaccination |  |  |  |  |  |  | BARS - Healthcare Monitoring | 1 | 2 | 3 | 4 | 5 | 6 | 7
BARS.STAR | TRUE |  | VIMIS RF AKiNEO |  |  |  |  |  |  | BARS.STAR | 1 | 2 | 3 | 4 | 5 | 6 | 7
Vaccination | TRUE |  | VIMIS RF Oncology |  |  |  |  |  |  | Vaccination | 1 | 2 | 3 | 4 | 5 | 6 | 7
VIMIS RF AKiNEO | TRUE |  |  |  |  |  |  |  |  | VIMIS RF AKiNEO | 1 | 2 | 3 | 4 | 5 | 6 | 7
VIMIS RF Oncology | TRUE |  |  |  |  |  |  |  |  | VIMIS RF Oncology | 1 | 2 | 3 | 4 | 5 | 6 | 7
VIMIS RF Prevention | FALSE |  |  |  |  |  |  |  |  | VIMIS RF Prevention | 1 | 2 | 3 | 4 | 5 | 6 | 7
VIMIS RF CVD | FALSE |  |  |  |  |  |  |  |  | VIMIS RF CVD | 1 | 2 | 3 | 4 | 5 | 6 | 7
HMP | FALSE |  |  |  |  |  |  |  |  | HMP | 1 | 2 | 3 | 4 | 5 | 6 | 7
Outside ARM | FALSE |  |  |  |  |  |  |  |  | Outside ARM | 1 | 2 | 3 | 4 | 5 | 6 | 7
Military registration | FALSE |  |  |  | Hard-50% |  |  |  |  | Military registration | 1 | 2 | 3 | 4 | 5 | 6 | 7
Hospital physician | FALSE |  |  |  |  |  |  |  |  | Hospital physician | 1 | 2 | 3 | 4 | 5 | 6 | 7
Diagnostics | FALSE |  |  |  |  |  |  |  |  | Diagnostics | 1 | 2 | 3 | 4 | 5 | 6 | 7
Dispensary registration | FALSE |  |  |  |  |  |  |  |  | Dispensary registration | 1 | 2 | 3 | 4 | 5 | 6 | 7
Remote monitoring | FALSE |  |  |  |  |  |  |  |  | Remote monitoring | 1 | 2 | 3 | 4 | 5 | 6 | 7
Health diary | FALSE |  |  |  |  |  |  |  |  | Health diary | 1 | 2 | 3 | 4 | 5 | 6 | 7
Unified registry | FALSE |  |  |  |  |  |  |  |  | Unified registry | 1 | 2 | 3 | 4 | 5 | 6 | 7
User information support | FALSE |  |  |  |  |  |  |  |  | User information support | 1 | 2 | 3 | 4 | 5 | 6 | 7
IPRA | FALSE |  |  | Positions |  |  |  |  |  | IPRA | 1 | 2 | 3 | 4 | 5 | 6 | 7
IEMC | FALSE |  |  | Analytics | TRUE |  |  |  |  | IEMC | 1 | 2 | 3 | 4 | 5 | 6 | 7
Call center | FALSE |  |  | Systems Analyst | TRUE |  |  |  |  | Call center | 1 | 2 | 3 | 4 | 5 | 6 | 7
 |  |  |  | Business Analyst | FALSE
 |  |  |  | Development | FALSE
 |  |  |  | Product Manager | FALSE
 |  |  |  | Department Manager | FALSE
 |  |  |  | Team Leader | FALSE |  |  |  |  | The formula should not only find numbers at the intersection of rows and columns and write them into the range starting from the green cell, but also multiply them by 3 and add percentages to the result depending on the complexity. There is data validation with the required percentages. The most important condition is that there is must be only one function and it calculates everything automatically.