Spreadsheet: 725392d1616665791-edit-formula-not-to-consider-blank-cells-with-formulas-book3
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Desired results
MO-1 | Beverage |  | Beverage | [Item] Tea | [Item] Juice |  | Box A | [NAME] | Bag S |  |  |  |  |  | MO-1 | Beverage | [Item] Tea
MO-1 | Food |  | Flower | [Item] Tulip |  |  | [NAME] | [NAME] | Bag M |  |  |  |  |  | MO-1 | Beverage | [Item] Juice
MO-2 | Flower |  | Furniture | [Item] Table | [Item] Chair | [Item] Couch | Box C | [NAME] | Bag L |  |  |  |  |  | MO-1 | Beverage | Box A
MO-3 | Furniture |  | Food | [Item] Bacon | [Item] Egg |  | Box D | [NAME] | Bag XL |  |  |  |  |  | MO-1 | Beverage | [NAME]
MO-4 | Food |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-1 | Beverage | Bag S
MO-5 | Food |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-1 | Food | [Item] Bacon
MO-6 | Flower |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-1 | Food | [Item] Egg
[NAME] | Flower |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-1 | Food | Box D
[NAME] | Beverage |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-1 | Food | [NAME]
MO-8 | Furniture |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-1 | Food | Bag XL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-2 | Flower | [Item] Tulip
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-2 | Flower | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-2 | Flower | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-2 | Flower | Bag M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-3 | Furniture | [Item] Table
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-3 | Furniture | [Item] Chair
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-3 | Furniture | [Item] Couch
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-3 | Furniture | Box C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-3 | Furniture | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-3 | Furniture | Bag L
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-4 | Food | [Item] Bacon
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-4 | Food | [Item] Egg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-4 | Food | Box D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-4 | Food | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-4 | Food | Bag XL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-5 | Food | [Item] Bacon
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-5 | Food | [Item] Egg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-5 | Food | Box D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-5 | Food | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-5 | Food | Bag XL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-6 | Flower | [Item] Tulip
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-6 | Flower | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-6 | Flower | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-6 | Flower | Bag M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Flower | [Item] Tulip
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Flower | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Flower | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Flower | Bag M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Beverage | [Item] Tea
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Beverage | [Item] Juice
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Beverage | Box A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Beverage | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Beverage | Bag S
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-8 | Furniture | [Item] Table
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-8 | Furniture | [Item] Chair
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-8 | Furniture | [Item] Couch
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-8 | Furniture | Box C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-8 | Furniture | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO-8 | Furniture | Bag L