Forum Discussion
copy text of other cell if there's a text in another
Hello: I have two sheets in excel. I want to copy the text of sheet one in sheet two if there's a text in one of the colums in sheet 2. So if in cell U3 in sheet 2 I have an "X", I want that the ...
=IF(ISTEXT(U3),sheet1!A3,"")Does this formula return a result similar to what you are looking for?
Sheet1:
Sheet2: