If refering cell is empty, display 0

[RodneyW]

I have this formula: =IFERROR(VLOOKUP($A20,'[Sep2018-VersionB.xlsx]Newsletters'!$B$3:$BZ$200,COLUMN()+14,FALSE),"") it works perfect if the cell being looked at has a value. If it doesn't, I'd like the destination cell to display 0. How do I modify my formula to produce that result?

Thanks in advance

 

[Joe4]

When you say "if the cell being looked at has a value", are you referring to $A20?
If so, then wrap it in an IF statement, i.e.
=IF($A20="",0,IFERROR(VLOOKUP($A20,'[Sep2018-VersionB.xlsx]Newsletters'!$B$3:$BZ$200,COLUMN()+14,FALSE),""))

 

[BarryL]

By destination, do you mean the cell where the formula is being entered? if so its just

=IFERROR(VLOOKUP($A20,'[Sep2018-VersionB.xlsx]Newsletters'!$B$3:$BZ$200,COLUMN()+14,FALSE),0)