Mirror Formula Help

[Mr Ray]

Im using the mirror formula to consolidate data (=“sheet1”!A1). If theres no value from “sheet1” it will display as “0” on “sheet2”. If there a way just to leave it blank?

ive tried vlookup and indmatch

thanks in advance

 

[Trebor76]

Hi Mr Ray,

Two options you might try:

• Format zeros as blanks i.e. something like this #,###"" or
• Use this formula =IF(LEN(Sheet1!A1)=0,"",Sheet1!A1)

Robert

 

[georgeawarriner]

Another similar approach if Sheet1!A1 is empty is to use =IF(Sheet1!A1="","",Sheet1!A1)

George

 

[sandy666]

or Options - Advanced - Display options for this worksheet - Show a zero in cells that have zero value (unchecked)

 

[Mr Ray]

WOW!!! It worked! Thank you

Hi Mr Ray,

Two options you might try:

• Format zeros as blanks i.e. something like this #,###"" or
• Use this formula =IF(LEN(Sheet1!A1)=0,"",Sheet1!A1)

Robert

 

[Trebor76]

Thanks for letting us know and you're welcome