Hello,

I have a sheet that picks up data from another. The formula is the

='Master Data'!AW35

But when there is no value to return it returns a 0. Is there anway i can change this so that it is just blank.???

Thanks