One way:

In the target:

A1: =IF([Source.xls]Sheet1!A1="","N","Y")

Copy as needed.



In article ,
Jeff wrote:

Hi There -

I have two Excel workbooks where one is supposed to be the "source" for
information in another which we will call "target". I would like to be able
to say if the value of the cell is blank in the source it will show up in the
target as N for no and if there is a value in the source cell the
corresponding target cell displays a Y for yes.

Does anyone know how to do this?

Many thanks!