If "No" in column B, brings value in column A; otherwise move to next row

[crismat09]

I have 3 columns, where column C should only display the information from column A if column B contains "NO". Any suggestion?

A	B	C (if B has "NO", bring data from column A)
20786WAD	-
FPAC	-
GLBL	-
BTRS	NO
ABMD	NO
LFG	NO

 

[Fluff]

How about

=if(b2="No",a2,"")

 

[crismat09]

How about

=if(b2="No",a2,"")

How about

=if(b2="No",a2,"")

Using "=if(b2="No",a2,"")" does not fix all the issue...My end goal is having in column C only the values that show "No" in B...in summary, cell C1 should not be blank, but show BTRS.

for the response "

=if(b2="No",a2,"")

", is this a VBA code? if so, I have zero knowledge in VBA

 

[Fluff]

No that's a formula that you put into C2 & fill down.