If cell contains this, then [1], or [2], or leave blank

[MYMunshi]

Hi

I have the following data:

[TABLE="width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]WT/PT[/TD]
[TD]WTE[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


In general, in column A, 1=WTE and 2=PTE.

In column B, I need cell B3 to say:

- if cell A3 contains "1", then "WTE". If cell A3 contains "2", then "PTE". If neither, then leave cell blank.

Any help pleeease with a formula??

Thank you kindly

Yousuf.

 

[Logit]

.
I believe your data will begin on Row 2.

If B2, paste this formula, then drag down as far as required :

=IF(A2=1,"WTE",IF(A2=2,"PTE",""))

 

[frank_AL]

Enter this formula in cell B3 and then copy down however many rows you have.
=IF(A3=1,"WTE",IF(a3=2,"PTE",""))

 

[MYMunshi]

Thank you and thumbs up to you both, the both solutions helped

 

[Logit]

You are welcome.