Convert numeric value to specific text

[ExcelUser2707]

Hi experts,

I require your valuable help.

I am frequently doing one exercise manually with the support of filter activation. The scenario is as follows. (I am using MS Office 2013)

Column “A” having numeric value in a range of 2001 To 2999.

I want to covert this range to specific text. E.g. 2001 To 2018 will convert to “PROJECT 1” , 2171 To 2181 will convert to “Project 9” and so on.

There is any code or formula will help me to convert numeric value in to text.

Sample file is attached for your reference.

Please help in this regards.

Thanks & Regards

Amar K

[FDibbins]

If you just have those 2 ranges, try this...
=IF(A2<2018,"Project1",IF(AND(A2>2170,A2<=2181),"Project9",""))

[:) Sixthsense :)]

	J	K	L
1	Start	End	New Value
2	2001	2018	Project1
3	2171	2181	Project9

	I
2	=IFERROR(LOOKUP(2,1/((A2>=$J$2:$J$3)*(A2<=$K$2:$K$3)),$L$2:$L$3),A2)

Drag it down...

[ExcelUser2707]

Thanks Sixthsense

Your suggested formula is working very well.

Your elaboration is pleasant.

Thanks a lot, god bless you

Regards

Amar K

[:) Sixthsense :)]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[ExcelUser2707]

Thanks FDibbins,

Thanks a lot for your prompt reply.