P.S.

That formula is based on your posted table. (which doesn't make any sense to
me!)

Biff

"Biff" wrote in message
...
Hi!

Try this:

=IF(ISNUMBER(MATCH(A2,G:G,0)),INDEX(A1:D1,MATCH(A2 ,A2:D2,0)),"")

Biff

"Cooch1070" wrote in message
...
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 A2's 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?????