Hiding 0's and not formulas.

[fishcakes]

I have antoher worksheet that feeds (Mapped/formulas) into the below worksheet. Is there a way that I can hide the below numbers/values untill the 1st worksheet/cells are populated?

 

[Joe4]

Are they all coming from formulas?

If so, and you have a formula like:

=Sheet1!A1

you can update your formulas to:

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

Or you could use Custom Formatting or Conditional Formatting to hide the zeroes.
Just note if you do that, and it is trying to pull a legit zero value from the other sheet, it will hide that too.
So the formula option may be preferrable.

 

[fishcakes]

Yes, most of the formulas are what you had described, I tried it and it works, excellent, thank you.

But there are still some formulas like the following..

=IF(O8=Dropdown!AR84,Dropdown!AU84)

That show FALSE

=VLOOKUP('Global Setup Form'!T8,'Global Dropdown'!A:B,2,FALSE)
That show #N/A

 

[Joe4]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’).

With this formula,

=IF(O8=Dropdown!AR84,Dropdown!AU84)

an IF formula has three arguments:

=IF(condition to check, what to return if condition true, what to return if condition false)

You left off the third argument (what to return if condition is false). If you do that, and the condition is FALSE, it will return the word FALSE (because you haven't told it otherwise).
Change it to this:

=IF(O8=Dropdown!AR84,Dropdown!AU84,"")

If you are using Excel 2010 or newer, you can use the IFERROR function around your VLOOKUP, i.e.

=IFERROR(VLOOKUP('Global Setup Form'!T8,'Global Dropdown'!A:B,2,FALSE),"")

 

[fishcakes]

Thanks joe, this is perfect! I have also updated by info!

 

[Joe4]

You are welcome.
Glad I was able to help!