stilwellj1983
New member
- Joined
- Sep 23, 2019
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Office 365
I have a document that I would like to lookup the far left column but both my row and column are floating. see example below. In the formula I would know 1 - 6 and the name, I want to return the A - F.
1 | 2 | 3 | 4 | 5 | 6 | |
A | Steve | John | Joe | Mike | Gray | Hanna |
B | John | Joe | Mike | Gray | Hanna | Steve |
C | Joe | Mike | Gray | Hanna | Steve | John |
D | Mike | Gray | Hanna | Steve | John | Joe |
E | Gray | Hanna | Steve | John | Joe | Mike |
F | Hanna | Steve | John | Joe | Mike | Gray |