I have a cell (say B1) that I want to put some text into, but only when another cell (cell A1) is blank. That cell (A1) has a formula in it (simply it says [='Drop-down data'!$C3], so it is just getting text copied in from cell C3 on another worksheet. If A1 is populated with this text then I want the selected text in the formula I have put into cell B1 to appear, but not otherwise. But I can't seem to do anything. I have tried all the IF(A1="","","text"), and tried ISBLANK, but to no avail.