Empty cells reporting a value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using a V-lookup comand from one spreadsheet in a
workbook to another from the same workbook. This should
report to me a string of values in the destination cells
in which some should be blank since there was no value in
that cell, but the destination cell is reporting a "0" I
have nothing entered in the referenced cell and have
tried the clear contents function and delete but nothing
seems to help. This is my formula, any ideas??

=VLOOKUP(Specs!$C$2,Specs!$I$4:$U$18,9)
 
Hi
try
=VLOOKUP(Specs!$C$2,Specs!$I$4:$U$18,9,0)
or
IF(VLOOKUP(Specs!$C$2,Specs!$I$4:$U$18,9,0)="","",VLOOKUP(Specs!$C$2,Sp
ecs!$I$4:$U$18,9,0))
 
Back
Top