Hey...I got it to work!!!! THANKS!!!!!!!!!!!!!!!!!!!!!!!!!!!

This what the end result looks like:

=IF(WMMapping!B2="","N","Y")

Ok, so this is just for one cell in the target workbook column. How do I
get this logic to apply to the entire column based on the entire column of
the source workbook?

"Jeff" wrote:

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!