Akinrotimi
Board Regular
- Joined
- Aug 8, 2011
- Messages
- 87
Hello,
I have a dataset where I want to locate the person with a value in a particular row.
The table below is on range A1:E5
<tbody>
</tbody>
I want to search for the recipient of any value on any row,for example 139 should be Neli for all the rows in the above example.
Expected result is :
<tbody>
</tbody>
Every help would be appreciated.
Thanks
I have a dataset where I want to locate the person with a value in a particular row.
The table below is on range A1:E5
Boyle | Hayle | Coyle | Neli | Coile |
-175 | 0 | 178 | 139 | -142 |
-175 | 0 | 178 | 139 | -142 |
-175 | 0 | 178 | 139 | -142 |
-175 | 0 | 178 | 139 | -142 |
<tbody>
</tbody>
I want to search for the recipient of any value on any row,for example 139 should be Neli for all the rows in the above example.
Expected result is :
-175 | BOYLE |
178 | COYLE |
139 | NELI |
-142 | COILE |
<tbody>
</tbody>
Every help would be appreciated.
Thanks