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.
 
Back
Top