Excel Show Data Based On Condition

[varunwalla]

Need to print the value

• In column J if it is B then value of column F should be shown in column K
• In column J if it is S then value of column E should be shown in column K

Print Value.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1	No	SYM	LTP	OPN	HGH	LW	PC	PDC	CHNG	B/S	VALUE	EXEPECTED OP
2	1	CSK	30.35	30	32.35	30	30.8	-0.45	-1.46	B		30
3	2	CTI	187.25	190	190	185.7	191.6	-4.35	-2.27	S		190
4	3	BBA	46.1	46.7	47.05	45.75	47.3	-1.2	-2.54	0
Sheet1

Cell Formulas
Range	Formula
J2:J4	J2	=IF(D2=F2,"B",IF(D2=E2,"S",))

 

[etaf]

=IF(J2="B",F2,IF(J2="S",E2,""))

you may also want to put a value in for J2 does not equal B or S The FALSE condition
=IF(D2=F2,"B",IF(D2=E2,"S",))
a blank for example
=IF(D2=F2,"B",IF(D2=E2,"S",""))

 

[varunwalla]

=IF(J2="B",F2,IF(J2="S",E2,""))

you may also want to put a value in for J2 does not equal B or S The FALSE condition
=IF(D2=F2,"B",IF(D2=E2,"S",))
a blank for example
=IF(D2=F2,"B",IF(D2=E2,"S",""))

thanks it works

 

[etaf]

you are welcome