1

Some of the referenced cells are blank and I would like that to be carried over instead of returning "0" in the cell

This is my formula -

=VLOOKUP(B2, SKUs!A$2:$E$7, 3, FALSE)

Thanks for any assistance!

Steven
  • 13
  • 1
  • 3

2 Answers2

1
=IF(VLOOKUP(B2,$A$2:$E$7,3,FALSE)="","",VLOOKUP(B2,$A$2:$E$7,3,FALSE))

or, if you have office 365

=LET(x,VLOOKUP(B2,$A$2:$E$7,3,FALSE),IF(x="","",x))
Ron Rosenfeld
  • 9,461
0

From Hide or display all zero values on a worksheet

Click File > Options > Advanced.

Under Display options for this worksheet, select a worksheet, and then do one of the following:

  • To display zero (0) values in cells, check the Show a zero in cells that have zero value check box.

  • To display zero (0) values as blank cells, uncheck the Show a zero in cells that have zero value check box.

This can be done per-worksheet or workbook - I don't believe it can be specified per-function.

Cpt.Whale
  • 10,914