a formula to read first 3 values of a text

[Marq]

I have a spread sheet that i am needing a formula in cell "AE3" in it that executes the following:

Take the first 3 letters of the value of cell "M3" and if those first three letters equal RUP then populate AE3 with "Run Unit Price".....but if the first three letters in M3 equal CTP then populate AE3 with "Center Time Price".....if the first 3 letters don't equal anything in my formula then leave AE3 blank

the values in M3 would look something like this RUP111980

I have only given two acronyms for this example but I will actually need 6 in the total formula....i just need two to get the ball rolling.

Any help would be appreciated

 

[Fluff]

How about
=IF(LEFT(M3,3)="RUP","Run unit price",IF(LEFT(M3,3)="CTP","Center Time Price",""))

 

[Fluff]

Another option is to setup a lookup table like

Excel 2013/2016
	I	J
8	RUP	Run unit price
9	CTP	Center Time Price
Report

And then use
=IFERROR(INDEX(J8:J9,MATCH(LEFT(M3,3)&"*",I8:I9,0)),"")

 

[Marq]

How about
=IF(LEFT(M3,3)="RUP","Run unit price",IF(LEFT(M3,3)="CTP","Center Time Price",""))

that works!..thanks!

 

[Fluff]

You're welcome & thanks for the feedback