I want to use the value in one cell e.g. RL8-CC1 to provide the matching
value in a different colun in the same row.

e.g. RL8-CC1 is in cell D:24 and the lookup value I am after is Repair Line
8 - Chain Conveyor 1 which is in cell E:24