So I have this
=IF(INDIRECT(N1&"!ah7")=0,"",INDIRECT(N1&"!ah7"))
I have a header sheet. in this sheet I have a drop down selection that picks another sheet, once I`ve choose the sheet the data from that sheet is displayed in the header sheet. That's all well and good.
If the sheet returned has zero`s in it then it prints nothing
I don`t want that, if the value is 0 then print that value.
But some cells won`t have anything in there at all.. and I want it to print nothing if there is no data at all
Signature/Avatar nuking: none (can be changed in your profile)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
