Combining few columns logically

[gorav]

Hi Friends
I just want to know that how can we combine 2 or 3 columns logically?

I ll explain :
Suppose we have a work sheet of 10 columns & 50 entries.there 3rd column is of some data which is in numbers.I want to check that if in 3rd column in any row the number is starting with 1 then 5th column of that row should be fille up by " xxx " .
The number in 3rd row can be either single digit or multi digit but should from 1.
Similarly for numbers starting with 2 I have to put say " yyy".
This Way we have to proceed.

Waiting for your swift response . . .

Thanx
Regards
gorav

[JBeaucaire]

=IF(LEFT(C2)="1","xxx",IF(LEFT(C2)="2","yyy",""))

Insert into E2 and copy down as needed.

[sglife]

I think this is what you need

=CHOOSE(LEFT(C1,1),"xxx","yyy","zzz")