Sorry for the late response .. my goal is to check each cell in the B column against entire F column . and to obtain the result of the symbol listed next to it (cell G).

Next issue is, that the names in Column B and Column F do not match 100 percent, but the first word usually does .
Is there a way to overcome this as well ?