Reference cell across sheets with no value

**BeckyW19** · 08-16-2016, 10:56 AM

Hi,

I am trying to reference a list of cells containing number values on a different sheet. Some cells contain no value, others 0+. When referencing the cells, it all works fine, except for the cells which contain no value, these cells are filled with 0.
Is anyone able to suggest a way around this?

Thanks,

Becky

**AliGW** · 08-16-2016, 10:57 AM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**BeckyW19** · 08-16-2016, 11:08 AM

Hi,

I have uploaded an attachment demonstrating my issue. As you can see, in the original data table there are cells with numerical values and others with no data. When cross referencing these cells into the referenced data table, the empty cells are filled with 0. How can I cross reference and keep it so empty cells remain empty?

Thanks for your help,

Becky