Lookup text in 1 column and make notations in another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nordic - 03 May 2008 20:38 GMT

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

Reply to this Message

Gord Dibben - 03 May 2008 20:58 GMT

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

Entered in B1 and copied down.

Gord Dibben MS Excel MVP

>How do I make different notations in 1 column for different texts in another?
>
[quoted text clipped - 9 lines]
>Thanks again for your help.
>Nordic

Reply to this Message