I want to look at a cell and if it has a certain value, return another
value in my target cell but if it has some other value, I what excel to
look at a table and find the value and return the cell value?

For example. I have a cell where the value is SP. If the value is SP,
then put Super Puppy in my target cell. But if excel looks at the cell
and it is not SP, but TO, I want excel to go to a table and lookup a
then value in the cell (TO) and put Totally Outrageous in that cell. If
the cell has something else, it would lookup that value and place it in
that cell.

Anyone know how to do this?

Thanks.