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

[MYMunshi]

Hi

I have the following data:

1	A	B
2	WT/PT	WTE
3	1
4	1
5	2
6	2

<tbody>
</tbody>

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.