Try something like

=IF(A1="SP","Super Puppy",VLOOKUP(A1,B1:C10,2,FALSE))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



wrote in message
oups.com...
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.