Need to Column C to equal the text in Column G based on the match the value in Column B.
I do have Column C matching the row in which the value is found (based on columns B and F)
Column C's Formula =MATCH(B1,$F$1:$F$39,0)
In the first row, you'll see that I found the row its corresponding value row is in. In CELL C1 for example, I would want to see