Hi! I am coming across a road block and it seems like what I am trying to do is simple enough, but everything I have tried does not work. I am wondering if maybe it’s because there is already a formula but I have hidden with =IFNA.. yada yada. I will provide screenshots so you can see what I am trying to do. The examples I provide are just that.. examples for the sake of this exercise. 

Example: Bit of Background: I sell booksets to bookstores across the US and Canada and I have 4 types of booksets. Book set 1 contains 2 books in a set; Vol. I & Vol. II. Book set 2 also contains 2 books in a set; Vol. III & Vol. IV. Book Set 3 contains the full set Vols. I-IV and finally Book Set 4 contains the same as Book Set 3 except the books are signed.

What I am trying to do: A book store in Canada bought 250 units of book set 1. I am creating an “invoice” however, for customs purposes, I have to list what is included in the set and their descriptions (Cells A6-A9). Now, I have VLookup formulas in those cells, including cells A10-A12 as I have other bookstores that purchase Bookset #3 and Bookset #4 but I have them hidden w/ IFNA formula. I also have simple formulas in cells B6, B8, B10, & B12 (=B2) See screenshots below.

How can I hide the quantities that are in B10 & B12 when A10 and A12 does not return a value? I have tried IF formulas, I have tried conditional formatting, and nothing I have tried worked so I am stumped. I know I can simply just highlight the cell and make it white but then I’d have to remember to undo that when I sell a book set that contains all 4 books and need the values that are in B10 & B12, if that makes any sense at all. More screenshots provided below

Any help at all would be much appreciated! Thanks!

​Hi! I am coming across a road block and it seems like what I am trying to do is simple enough, but everything I have tried does not work. I am wondering if maybe it’s because there is already a formula but I have hidden with =IFNA.. yada yada. I will provide screenshots so you can see what I am trying to do. The examples I provide are just that.. examples for the sake of this exercise.  Example: Bit of Background: I sell booksets to bookstores across the US and Canada and I have 4 types of booksets. Book set 1 contains 2 books in a set; Vol. I & Vol. II. Book set 2 also contains 2 books in a set; Vol. III & Vol. IV. Book Set 3 contains the full set Vols. I-IV and finally Book Set 4 contains the same as Book Set 3 except the books are signed.What I am trying to do: A book store in Canada bought 250 units of book set 1. I am creating an “invoice” however, for customs purposes, I have to list what is included in the set and their descriptions (Cells A6-A9). Now, I have VLookup formulas in those cells, including cells A10-A12 as I have other bookstores that purchase Bookset #3 and Bookset #4 but I have them hidden w/ IFNA formula. I also have simple formulas in cells B6, B8, B10, & B12 (=B2) See screenshots below.How can I hide the quantities that are in B10 & B12 when A10 and A12 does not return a value? I have tried IF formulas, I have tried conditional formatting, and nothing I have tried worked so I am stumped. I know I can simply just highlight the cell and make it white but then I’d have to remember to undo that when I sell a book set that contains all 4 books and need the values that are in B10 & B12, if that makes any sense at all. More screenshots provided belowAny help at all would be much appreciated! Thanks!  Read More

​