Good Morning,
Here is what I have:
In column B is a employee number, in columns C through R is a bunch of data that is irrelevance to this need, but then in column S is where another formula returns a value of "None", or another value such as "COBC", or a few other possible items. Below all of this data, also in column B is a list of just the unique employee ID numbers.
What I need is formula/array that will go with the unique employee ID list, look at the tables above and pull out a value for that specific employee ID should a value in a column P be something other than "None". If it helps each employee ID could appear in the table up to 3 times and as few as once. Should the formula/array not find anything other than "None" than "None" should be the value that is shown.
Here is a data example:
<colgroup><col span="8"></colgroup><tbody>
</tbody>
Any help is appreciated and thank you in advance.
Here is what I have:
In column B is a employee number, in columns C through R is a bunch of data that is irrelevance to this need, but then in column S is where another formula returns a value of "None", or another value such as "COBC", or a few other possible items. Below all of this data, also in column B is a list of just the unique employee ID numbers.
What I need is formula/array that will go with the unique employee ID list, look at the tables above and pull out a value for that specific employee ID should a value in a column P be something other than "None". If it helps each employee ID could appear in the table up to 3 times and as few as once. Should the formula/array not find anything other than "None" than "None" should be the value that is shown.
Here is a data example:
A | B | C | D | E | F to R | S | |
1 | Jan | Emp1 | Name | Name | City | Results | None |
2 | Feb | Emp2 | Name | Name | City | Results | None |
3 | Mar | Emp3 | Name | Name | City | Results | None |
4 | Jan | Emp1 | Name | Name | City | Results | None |
5 | Feb | Emp2 | Name | Name | City | Results | None |
6 | Mar | Emp3 | Name | Name | City | Results | Other |
7 | Jan | Emp1 | Name | Name | City | Results | None |
8 | Feb | Emp2 | Name | Name | City | Results | COBC |
9 | Mar | Emp3 | Name | Name | City | Results | None |
Emp1 | Should return "None" | ||||||
Emp2 | Should Return "COBC" | ||||||
Emp3 | Should Return "Other" |
<colgroup><col span="8"></colgroup><tbody>
</tbody>
Any help is appreciated and thank you in advance.