copy text of other cell if there's a text in another

Occasional Visitor

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 name in A3 in sheet 1 been copied in cell A3 in sheet 2.

Amazing thing will be if possible to eliminate automatically the cells in sheet 2 that doesn't follow the rule, so all the ones in wich there's text, came one by another. Imposible uh?

Hope my question to be clear, sorry.

Kindest regards

1 Reply

@Sandramedina 

=IF(ISTEXT(U3),sheet1!A3,"")

Does this formula return a result similar to what you are looking for?

 

Sheet1:

sheet 1.JPG

 

Sheet2:

sheet 2.JPG