View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nordic Nordic is offline
external usenet poster
 
Posts: 7
Default Lookup text in 1 column and make notations in another

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