3-D cell reference returns 0

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

Guest

I am splitting up a large general table into several smaller specific tables. I would like the smaller tables to reference the appropriate cells in the larger table. I am using the formula =MASTER!A3, but when there is an empty field in the large table (MASTER), the function returns a 0. I would like the field to remain empty. Any suggestions would be helpful. Thanks

Luke
 
I am splitting up a large general table into several smaller specific tables.
I would like the smaller tables to reference the appropriate cells in the
larger table. I am using the formula =MASTER!A3, but when there is an empty
field in the large table (MASTER), the function returns a 0. I would like the
field to remain empty. Any suggestions would be helpful. Thanks.
Click to expand...

If the source cells are empty, you could have formulas referring to them return
"" using formulas like

=IF(ISBLANK(foo!X99),"",foo!X99)

but Excel provides no means whatsoever to return 'blank' from formulas.
 
You must log in or register to reply here.

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

Return cell referance of the first cell that equals a value? 5
Pivot Table with Data Model Connection - getpivotdata reference issue 0
VBA Multiple Line handling with Split() 1
Return an absolutely empty cell ... but not "" 3
#DIV/0! in PivotTable 3
Need a formula 2
Peculiar default cell format 1
Find values in table and return row/column name 7

Back
Top