Good morning,
What method should I use, I was thinking of using INDEX, however, it will
not work for me.
I can have more than 10 columns and more than 10 rows of data.
In my one cell, I would like to have the result from the first column to
have returned. In in another cell, I would like to have the result from the
second colum, if applicable. All the other columns are just data.

For example, if column M on my data sheet has the name Gretzky, then I would
like to see in column N the code 25 and column O Rangers. Does this make
sense? If there is a name that is not on the list, then leave alone and do
not fill in the code.

Code Table 1 Alternates Alternates Alternates
25 Rangers Messier Gretzky
26 Devils
27 Yankees Jeter Ruth Mantle
28 Red Sox Yaz Martinez
29 Blue Jays
30 Indians Powell
31 Islanders
32 Blues
33 Reds Rose
34 Angels Carew
35 Lakers Johnson
36 Celtics Bird McHale