=LOOKUP(P1,{"Advanced","Regular","Title"},{"A","R" ,"X"})

Entered in B1 and copied down.


Gord Dibben MS Excel MVP

On Sat, 3 May 2008 12:38:01 -0700, Nordic
wrote:

How do I make different notations in 1 column for different texts in another?

In column P I have Regular, Title, Advanced. I want to note R for Regular,
A for Advanced, and X for Title in column B.

Example:
Column B Column P
X Title
R Regular
A Advanced

Thanks again for your help.
Nordic