Copy data but leave target cell blank

**MarcoAUA** · 03-17-2012, 02:08 PM

Hi you'll,

Cell Data!A5 has a value.
This value is copied to Grades!A5 through this formula ="Select " & TEXT(Data!A5,)
the cell in Grades has a hyperlink to select an entire row.
What I like to achieve is when Data!A5 is blank, Grades!A5 also stays blank and not shows "select".

Any bright ideas any one?

Marco.

**davesexcel** · 03-17-2012, 02:14 PM

=if(Data!A5="","","Select " & TEXT(Data!A5,))

**MarcoAUA** · 03-17-2012, 02:21 PM

Thanks Dave,

The result is #Value.
When I change it to =IF(Data!A5="","Select " & TEXT(Data!A5,)) it returns True when Data!A5 is populated and "Select when Data!A5 is blank.

Any ideas?

Marco.