Dear Spreadsheet Superiors,

Objective is to fill cells in Column 'C'.

If a cell in Column 'B', has the word 'Yes', then the adjacent cells in column C, are populated with the values(text), from column A. Screen shot attached.

I thought the correct Formula, entered into cells in column 'C', was : =IF(B2=''Yes'',A2). But this does not work.
Capture.jpg
Any thoughts greatly appreciated.

Thanks.