Excel Worsheet formula - contain resolved value and not formula

[acseric]

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

 

[mole999]

=IF(Sheet2!A1="","",Sheet2!A1)

 

[acseric]

Awesome! Works like a charm!