foods

  1. P

    sum ifs + index match

    Hi, I'm trying to accomplish the following results: <tbody> #8cb5df[/URL] "]January #8cb5df[/URL] , colspan: 3"]Publix #8cb5df[/URL] "]2019 #8cb5df[/URL] "]2018 #8cb5df[/URL] "]2017 #8cb5df[/URL] "]Fruits Pear 6 10 2 Mango - 1 3 Banana 4...
  2. tlc53

    If Formula - Error when I extend Range

    Hi there, I have a basic formula =IF(D181=B268,B181,) This correctly returns "Dairy Foods" However, when I try to extend the range =IF(D181:D182=B268,B181:B182,) It returns #VALUE !, instead of "Dairy Foods". Does anyone know why it's going that? Thank you!
    • tlc53
    • Thread
    • error excel 2010 & vba foods formula if formula
    • Replies: 5
    • Forum: Excel Questions
  3. T

    Formula to Group Companies under Categories

    I have two excel lists. <tbody> List A Organization Category 1 Category 2 Category 3 Category 4 Category 5 Azure Standard Beans - CANNED Beans - DRY Beet - CANNED Mixed Fruit - FROZEN Onions - FROZEN Basic American Foods, Inc. Potatoes: Russett - FROZEN Beet - CANNED Garlic -...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top