Lookup text in 1 column and make notations in another

N

Nordic

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
 
G

Gord Dibben

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

Entered in B1 and copied down.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with the error: unable to filter on excel hc home school 0
Lookup text in 1 column and note it in another 1
Lookup order 2
Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
List all tables, including document structure 0
Unreadable text when viewing organization chart in Web version of Visio 365 0
Setting column width in a table with a macro is not working 0
How to center adjust text above and image in a two column document. 1

Top