I have a table with names going down the column, and then numbers in the 7
columns to the side. Below that, I created another column of all the
possible numbers. I then created a conditional to look through each number
column above and see if it will match the corresonding number of the cell I
am in below. If it matches, I need to it to display the name that
corresponds to the number match. However, it seems that it wont display the
name for some reason. I know the formula is right because if I were to
manipulate it so it would display a number instead, this works. It seems
that the problem is in displaying the name as it's not a number. Anyone know
an additional function I need to insert to get the name displayed?