hi guys is it possible to create a formula in a cell that refers to whether another cell is less than a number and then so it can copy text from another cell in a different sheet ?
View best response
thank you very much
only one problem, how do i stop it saying FALSE when it doesn't fall within the formula to copy the text i want ? i.e. i want the cell to remain blank or copy the text
@Twifoo Brilliant thank you