Basic Formula returns "0" when I would like a blank cell

[aabbey]

Hello I have built a channel list used for the entertainment/Live music industry.

I have used Data Validation in the Patch sheet so only specific things can be selected.

The Columns Stagebox/Patch (B) and Instrument (C) on the PATCH sheet must be duplicated in their respective places on the MONITORS Sheet. I have done this, however I don't want the cells to return "0" if the field is left blank on the PATCH Sheet but rather it be left blank. I have tried using the IF and IFERROR function but as a novice I am clearly messing it up somewhere.


The Excel document is attached if anyone wishes to have a crack at it.

Regards

[AlKey]

Maybe like this

Please Login or Register  to view this content.

[Glenn Kennedy]

1. Your DV in Patch column B is not working.

2. Monitors column C is set as text. Should be General.

3. Formulae in B:
=IF(Input[@[Stagebox/Patch]]="","",Input[@[Stagebox/Patch]])

4. and in C:
=IF(Patch!C2="","",Patch!C2)

[aabbey]

Thank you both for your help

[Glenn Kennedy]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.