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!!