If Function

[Oliullah_Siddique]

Dear Everyone,

Please suggest me a formula for the following excel:

	A	B	C	D	E	F
1	Particulars	Criteria 1	Result		Criteria 2	Result
2	101010	If A2 starts with 1, C2 will show BS	BS		If A2 starts with 1, F2 will show ASSET	ASSET
3	201010	If A3 starts with 2, C3 will show BS	BS		If A3 starts with 2, F3 will show LIABILITY	LIABILITY
4	301010	If A4 starts with 3, C4 will show PL	PL		If A4 starts with 3, F4 will show INCOME	INCOME
5	401010	If A5 starts with 4, C5 will show PL	PL		If A5 starts with 4, F5 will show EXPENSE	EXPENSE

Thanks in advance.

[#2 · Accepted solution]

@Oliullah_Siddique In C2 you could use:

=CHOOSE(LEFT(A2),"BS","BS","PL","PL")

and in F2:

=CHOOSE(LEFT(A2),"ASSET","LIABILITY","INCOME","EXPENSE")

 Copy down

[#3]

Thanks a lot. Your function worked very well @Riny_van_Eekelen.