Below is an example of what I have built. I want it to look at the list in
Col B and match it to the corresponding number below, then to display "Steve"
next to 1, "Joe" next to 2, and so on... I want this all to be automatic so
that in subsequent columns when the number changes, the name changes below as
well.

Col A Col B Col C
Adam 4 2
Steve 1 3
Frank 3 1
Joe 2 4

1: Steve Frank
2: Joe Adam
3: Frank Steve
4: Adam Joe

"Gaurav" wrote:

If you have to return BULSY, in the formula write "BULSY"

Hope this helps.

"bulsy" wrote in message
...
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?