Let XL create the proper path for you.

Open *both* WBs.

Click in the target cell of the target WB and enter an equal sign ( = ).

Navigate to, and click in, the source cell of the source WB, and then hit
<Enter.

This places a link formula in the target cell, with the proper path.

NOW, just build your IF() formula *around* the path that XL made for you in
that target cell.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jeff" wrote in message
...
Sorry for so many questions...

I entered the following in the desired cell in the target workbook:

=(WM Mapping!B2=""."N","Y")

Where WM Mapping is the name of the source workbook and B2 references the
cell in that workbook. As soon as I click on the green check I receive an
error message stating the the formula contains an error. Any idea's?

"Ragdyer" wrote:

Yes.
It is, in actuality, a zero length string.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jeff" wrote in message
...
Thanks for the reply.

I am basically trying to do and "IF" statement it seems. So from your
IF
statement how does it know to return N if the cell is blank otherwise
return
Y if there is a value? Does "" indicate a blank?

"Ragdyer" wrote:

You'll have to replace "Source" with the correct path and name to your
actual "source" WB:

=IF(Source!A1="","N","Y")

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may
benefit !
---------------------------------------------------------------------------
"Jeff" wrote in message
...
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!