Try this:

=IF(ISNA(VLOOKUP($A4,PMRollout,4,0)),
"",IF(VLOOKUP($A4,PMRollout,4,0)="","",
VLOOKUP($A4,PMRollout,4,FALSE)))

Biff

"Martha" wrote in message
...
My formula: =IF(ISNA(VLOOKUP($A4,PMRollout,4,FALSE)),"
",VLOOKUP($A4,PMRollout,4,FALSE))
Problem: It's returning a "0" value when source cell is blank instead of
the usual " ".
Notes:
--The name is defined as the =source workbook, source sheet, absolute
range
--Am using Paste-Special-Formulas only to preserve non-continuous
formatting
in destination column
--Source and destination columns both formatted as General; have also
tried
Text.
--Same formula has worked multiple times in same workbook
--Workbook does have thousands of lookups if that matters

Can anyone help? Thanks much,