Excel Copy Data from Primary Cell, then Secondary Cell if the Primary Cell is Blank.

I want to copy data from one cell using a formula.  However if that cell is blank then I want it to select a secondary cell to copy

Primary Data Column being copied from is in Column E
Secondary Data Column that I want to select is in Column C

New Data is in Column A
Julie LymanAsked:
Who is Participating?
 
Terry WoodsConnect With a Mentor IT GuruCommented:
=if(e2<>"",e2,c2)

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.