like this: =IF(Sheet1!e1<>"",Sheet1!b1,"NONE") You can modify it as your like. Just copy the formula to another row in sheet2 column a. P.S.: If this information was helpful, please rate this solution
...copy it to a blank worksheet. Create a blank workbook or worksheet. Select the example in the Help topic. Note Do not select the row or column headers. Selecting an example from Help Press CTRL+C. In ...
formula that will place the word "yes" if the sales team meets or exceeds goal of $3000, and the word "no" if they do not. HELLLLLPPPPP! Thanks :) Assumed I have this sheet below: | A | B ============
313 questions posted
Usually answered in minutes!
7,277 Questions
4,615 Questions
4,483 Questions
4,194 Questions
3,681 Questions