Home > IT Answers > Microsoft Windows > If-then looking for any text in a cell
ExcelBeginner
15 pts.
 If-then looking for any text in a cell
Microsoft Excel 2010, microsoft excel functions
This is what I'm trying to do: If cell A has any text in it, then look at cell B and populate cell C based on what is found in cell B.  If cell A is empty, do nothing.  Is it possible? L.

Software/Hardware used:
Excel 2010
ASKED: December 5, 2012  6:38 PM
UPDATED: December 5, 2012  7:21 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question. Michael Tidmarsh   11,410 pts. , ExcelBeginner   15 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

to answer the question you asked: Yes.

BigKat
 7,185 pts.
 

sorry, couldn’t resist.
in the ‘C’ column, you can use the formula: =IF(ISBLANK(A1),”",B1)

BigKat
 7,185 pts.
 

test

tlsanders1
 1,240 pts.