isna vlookup returning"0" instead of " "
 

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,

isna vlookup returning"0" instead of " "
 

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,

isna vlookup returning"0" instead of " "
 

Worked! Thanks a lot - will try on others where had same problem.

"T. Valko" wrote:

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,

isna vlookup returning"0" instead of " "
 

You're welcome. Thanks for the feedback!

Biff

"Martha" wrote in message
...
Worked! Thanks a lot - will try on others where had same problem.

"T. Valko" wrote:

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,