Converting Numeric Value (1,2or3) to text

[Juliemudd]

Hi, I have a range of data eg (B3:Q545) and I want to convert the field values, either 1, 2 or 3, into text. 1=Not Started, 2=In Progress, 3=Completed. How do I do this? I've tried the if function but I get the #VALUE error, I've tried V Look up also.

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

[Juliemudd]

Hi, thank you for your quick response - I had been catching up with work and signed off straight after my post. I have (I think) attached a sample for you

[davsth]

you could find and replace 1 with not started etc

a formula in other cells
=IF(C2=1,"Not Started",IF(C2=2,"In Progress",IF(C2=3,"Completed","")))

or
=IFERROR(LOOKUP(C2,{1;2;3},{"not started";"In progress";"Completed"}),"")

[BMV]

Please Login or Register  to view this content.

[Metoo7]

=CHOOSE(C2,"not started","In progress","Completed")