Not sure what formula to use. Currently I am using index match but whilst it is returning a result it is not quite returning what I want.
I have a table which contains the following info:
<tbody>
</tbody>
and so forth
What I need is a formula that matches a value say 7.1/Rg and returns the value from column A wherever reference is made to 7.1/Rg i.e. in this instance AAB and SAH to another sheet.
Any ideas?
Thanks
Fazila
I have a table which contains the following info:
Staff | Reg 1 | Reg 2 | Reg 3 | Reg 4 |
AAB | 7.1/Rg | |||
SAH | 7LA/Rg | 7LB/RG | 7.1/Rg | |
MAH | 9.7/Rg | 9BW/RG | 9BT/RG | |
AJA | 10W/Rg | 10H/Rg | 10M/RG |
<tbody>
</tbody>
and so forth
What I need is a formula that matches a value say 7.1/Rg and returns the value from column A wherever reference is made to 7.1/Rg i.e. in this instance AAB and SAH to another sheet.
Any ideas?
Thanks
Fazila