Copy value of column where associated column partially matches another column-CodePudding

My title is badly described as I am unable to describe it in one sentence.

I have Column A with a label and Column B showing its associated value.

I then have column C which is another label that could partially match Column A.

If there is a partial match, I want column F to show which label from Column C partially matches and then change its value to match the value in Column B and display the new value in Column G.

Sounds confusing but you can see from my image what I'm trying to achieve in Column G. The only bit I want to be achieved automatically is Column G to find the matches.

CodePudding user response：

Per screenshot:

=INDEX(B2:B10,MATCH(LEFT(G2#,8),A2:A10,0))