I am looking for a formula or a macro that will fill a value in column B if the value in column A is matches any of a set of values.
For example, Mike manages John, Christine and Harriet and Susan manages Bob, Steve and Vicki. I have tried using nested IF formulas and they don't work right, as I have over 200 employees and 12 managers to match (too many conditions for a standard if formula) and the data is column A is dynamic; it's a formula pulling specific raw data from another sheet. I'm well versed with formulas, but still learning a lot of VBA and macros, any help is much appreciated.
<tbody>
</tbody>
For example, Mike manages John, Christine and Harriet and Susan manages Bob, Steve and Vicki. I have tried using nested IF formulas and they don't work right, as I have over 200 employees and 12 managers to match (too many conditions for a standard if formula) and the data is column A is dynamic; it's a formula pulling specific raw data from another sheet. I'm well versed with formulas, but still learning a lot of VBA and macros, any help is much appreciated.
Employee | Manager |
John | |
Bob | |
Steve | |
Harriet | |
Christine | |
Vicki |
<tbody>
</tbody>