hammerhead13
Board Regular
- Joined
- Aug 4, 2008
- Messages
- 86
- Office Version
- 365
- 2019
- Platform
- Windows
- Mobile
I need a Formula that will find the Number in the Range D5:H8 and return a Name from Column C. For Example. If i Put "61" I want it to Return "Bill". Thanks in Advance.
C | D | E | F | G | H | |
5 | Bob | 10 | 2 | 54 | 24 | 3 |
6 | Bill | 15 | 61 | 64 | 7 | 63 |
7 | Ted | 123 | 90 | 67 | 43 | 23 |
8 | Fred | 23 | 65 | 22 | 53 | 42 |