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>
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...