isna vlookup returning"0" instead of " "

G

Guest

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,
 
T

T. Valko

Try this:

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

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ISNA Formula returning "False" instead of value 4
isna vlookup #n/a but not false 1
VLOOKUP returning #N/A 5
Vlookup returning #n/a 2
Vlookup - Returning 2nd match 4
Return 0 when if statement with VLOOKUP returns#N/A 3
Leave cell data (IF(ISNA(VLOOKUP) is TRUE instead of returning blank (" ") or #NA 6
Alternative of Vlookup function which improves speed 4

Top