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:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Staff[/TD]
[TD]Reg 1[/TD]
[TD]Reg 2[/TD]
[TD]Reg 3[/TD]
[TD]Reg 4[/TD]
[/TR]
[TR]
[TD]AAB[/TD]
[TD]7.1/Rg[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SAH[/TD]
[TD]7LA/Rg[/TD]
[TD]7LB/RG[/TD]
[TD]7.1/Rg[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MAH[/TD]
[TD]9.7/Rg[/TD]
[TD]9BW/RG[/TD]
[TD]9BT/RG[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AJA[/TD]
[TD]10W/Rg[/TD]
[TD]10H/Rg[/TD]
[TD]10M/RG[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Staff[/TD]
[TD]Reg 1[/TD]
[TD]Reg 2[/TD]
[TD]Reg 3[/TD]
[TD]Reg 4[/TD]
[/TR]
[TR]
[TD]AAB[/TD]
[TD]7.1/Rg[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SAH[/TD]
[TD]7LA/Rg[/TD]
[TD]7LB/RG[/TD]
[TD]7.1/Rg[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MAH[/TD]
[TD]9.7/Rg[/TD]
[TD]9BW/RG[/TD]
[TD]9BT/RG[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AJA[/TD]
[TD]10W/Rg[/TD]
[TD]10H/Rg[/TD]
[TD]10M/RG[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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