RDAVIS1976
New Member
- Joined
- Dec 28, 2016
- Messages
- 2
What I'm trying to build is a formula that will search a range of cells and return a specified text value if there's a match. Specifically I'm looking for names which may appear along a reports to hierarchy, 1-7. If the formula finds a particular name, any where in the range, I want it to return the name I specify.
For example, I have 3 managers named; Mountain Man, Dan Fountain, and Now Begin...what formula would I use to locate them based on the table below?
I was using - IF(ISNUMBER(SEARCH("Man, Mountain",H13:M13)),"Mountain Man",IF(ISNUMBER(SEARCH("Fountain, Dan",H13:M13)),"Dan Fountain",IF(ISNUMBER(SEARCH("Begin, Now",H13:M13)),"Now Begin"))) but it's not working
<colgroup><col span="6"></colgroup><tbody>
</tbody>
For example, I have 3 managers named; Mountain Man, Dan Fountain, and Now Begin...what formula would I use to locate them based on the table below?
I was using - IF(ISNUMBER(SEARCH("Man, Mountain",H13:M13)),"Mountain Man",IF(ISNUMBER(SEARCH("Fountain, Dan",H13:M13)),"Dan Fountain",IF(ISNUMBER(SEARCH("Begin, Now",H13:M13)),"Now Begin"))) but it's not working
Supervisor Level 1 Name | Supervisor Level 2 Name | Supervisor Level 3 Name | Supervisor Level 4 Name | Supervisor Level 5 Name | Supervisor Level 6 Name |
Man, Mountain | Krieg, Dave | Sweeny, Jim | Wilson, Russ | Baldwin, Doug | Sweeny, Jim |
Sweeny, Jim | Dilfer, Trent | Krieg, Dave | Fountain, Dan | Parcells, Bill | Parcells, Bill |
Parcells, Bill | Begin, Now | Parcells, Bill | Krieg, Dave | Sweeny, Jim | Krieg, Dave |
<colgroup><col span="6"></colgroup><tbody>
</tbody>