Setup a table, 2 columns by n rows, in M1:N10 say, with values of
1 Blue
2 Red
4 Yellow
etc

Then use

=VLOOKUP(B2,$M$1:$N$10,2,False)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"LilJazzyLady" wrote in message
...
I posted a similiar question before, but I don't think I was clear.
Here's
what I'm trying to do:

In colum B, each corresponding cell has a number (ex: B2 has a 1, B3 has a
4, etc). In Column D is where I want to return the text value. I need
the
formula to search the cell in Column B and if it finds a 1, to return the
value "Blue," a 2 to return "Red," a 4 to return "Yellow" and so forth.
An
If statement doesn't work because I have more than 7 conditions. What else
can I do here?

Hope that's clear.

Thanks!!