Dear All,
Could I please request some help on an issue that I have tried to resolve over the past two days to no avail. In the "Master" tab I have some unique IDs in column A, in column D of the same tab I want to input if they are a Manager, if they are I want to return the value in D1. To find out if they are a Manager the information is in the "source" tab. This is done by matching the Unique ID in column A of the source tab with the Unique ID in the master tab and from this searching fo the cells populated with a unique ID in columns B and C. What is the code for this?
Could I please request some help on an issue that I have tried to resolve over the past two days to no avail. In the "Master" tab I have some unique IDs in column A, in column D of the same tab I want to input if they are a Manager, if they are I want to return the value in D1. To find out if they are a Manager the information is in the "source" tab. This is done by matching the Unique ID in column A of the source tab with the Unique ID in the master tab and from this searching fo the cells populated with a unique ID in columns B and C. What is the code for this?
| Testing.xlsx | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | Unique ID | Duplicate check | Name | Manager | ||
| 2 | 0001525892 | 1 | Joe Bloggs | |||
| 3 | 0001525893 | 1 | Bart Simpson | |||
| 4 | 0001525894 | 1 | Home Simpson | |||
| 5 | 0001525895 | 1 | Maggie Simpson | |||
| 6 | 0001525896 | 1 | Marge Simpson | |||
| 7 | 0001525897 | 1 | James Bond | |||
Master | ||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| B2:B7 | B2 | =COUNTIF(A:A,A2) |
| Cells with Conditional Formatting | ||||
|---|---|---|---|---|
| Cell | Condition | Cell Format | Stop If True | |
| A1:B1 | Cell Value | duplicates | text | NO |
| Testing.xlsx | |||||
|---|---|---|---|---|---|
| A | B | C | |||
| 1 | Unique ID | Senior Manager | Junior Manager | ||
| 2 | 0001473341 | ||||
| 3 | 0001473342 | ||||
| 4 | 0001473343 | ||||
| 5 | 0001473344 | ||||
| 6 | 0001473345 | ||||
| 7 | 0001525892 | ||||
| 8 | 0001525893 | ||||
| 9 | 0001525894 | ||||
| 10 | 0001525895 | 0001525895 | |||
| 11 | 0001525896 | ||||
| 12 | 0001525897 | 0001525897 | |||
| 13 | 0000843034 | ||||
| 14 | 1010590120 | ||||
| 15 | 1000150347 | ||||
| 16 | 0001032885 | 0001032885 | |||
Source | |||||
| Cells with Conditional Formatting | ||||
|---|---|---|---|---|
| Cell | Condition | Cell Format | Stop If True | |
| C1 | Cell Value | duplicates | text | NO |
| C1 | Cell Value | duplicates | text | NO |
| B1 | Cell Value | duplicates | text | NO |
| B1 | Cell Value | duplicates | text | NO |
| A9:A11 | Cell Value | contains "2020 Removal - Was 2019 Inclusion" | text | NO |
| A9:A11 | Cell Value | ="Other" | text | NO |
| A9:A11 | Cell Value | ="2020 Exclusion - Confirmed" | text | NO |
| A9:A11 | Cell Value | ="2020 Exclusion - Potential TBC" | text | NO |
| A9:A11 | Cell Value | ="2020 Removal - Tagging Refresh" | text | NO |
| A9:A11 | Cell Value | ="2020 Inclusion - Tagging refresh" | text | NO |
| A9:A11 | Cell Value | ="2020 Inclusion - New" | text | NO |
| A9:A11 | Cell Value | ="2020 Inclusion - Continuing 2019 Inclusion" | text | NO |
| A9:A11 | Cell Value | ="Other" | text | NO |
| A9:A11 | Cell Value | ="2019 Exclusion - Confirmed" | text | NO |
| A9:A11 | Cell Value | ="2019 Exclusion - Potential TBC" | text | NO |
| A9:A11 | Cell Value | ="2019 Removal - Tagging Refresh" | text | NO |
| A9:A11 | Cell Value | contains "2019 Removal - Was 2018 Inclusion" | text | NO |
| A9:A11 | Cell Value | ="2019 Inclusion - Tagging refresh" | text | NO |
| A9:A11 | Cell Value | ="2019 Inclusion - New" | text | NO |
| A9:A11 | Cell Value | ="2019 Inclusion - Continuing 2018 Inclusion" | text | NO |
