I am trying to create a formula that will read a name and if that name
matches in another column, then it would return a value in a represented cell.

Column A B C D E F G
Row 1 6 5 4 3
ROW 2 Jags Eag Boy Bucs Tom
Row 3 Jerry
Row 4 Eag
Row 5 Fred

I need the one formulae to say if A2s values is represented anywhere in
column G, then return the value of 6. So for instance, B2, has a name Eag,
that value is one of the values in column G. I would need the formula to
return the value of 5. Any help?????