Excel Worsheet formula - contain resolved value and not formula

acseric

New Member
Joined
Sep 20, 2016
Messages
46
Hi All,

I have a workbook with 2 worksheets (Sheet1 and Sheet2)

All of the cells in Sheet1 contain formulas, that point to the same cell on Sheet2

For example on Sheet1 cell A1 contains: =Sheet2!A1

is there a way that I can have the cells on Sheet1 contain the values of the cells on Sheet2, and not the formulas?


My main issue is that empty cells on Sheet2 are resolving as '0' (not empty or blank). Is there a way to set the formula so that it resolves as blank instead of 0

I simply want the cells on Sheet1 that refer to empty cells on Sheet2 show as empty also (or blank)

Help with this is greatly appreciated.

Eric
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
=IF(Sheet2!A1="","",Sheet2!A1)
 

Watch MrExcel Video

Forum statistics

Threads
1,122,518
Messages
5,596,622
Members
414,082
Latest member
sasmita

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top