nested array

  1. J

    Multiple Layer VLOOKUP, or better alternative?

    Hello All! Trying to solve the following: A purchase order is placed for a product on DATE A. (For purposes of demonstration, let's say July 1, 2022) The product has a Part Number (which can be numeric or text) within a contract number (text) within a supplier number (text) Prices for each...
  2. W

    Sumproduct with a lookup nested inside

    Hello, I've spent quite a while trying to work out how to use sum product with a look up nested inside it. I'm trying to calculate the annual sum of payments received by a group. People in the group receive payments either weekly or monthly. I receive a regular report which contains: how...
  3. L

    Counting Data that Contains Multiple Variables

    Hi, I have a list of terms (list a) and a list of the states (list b) and I want to write a formula that counts when one of the values in list a contains one of the values from list b Example <tbody> list a list b cars to buy in florida florida florida places to buy cars new york new...
  4. S

    One To Many Relationship

    I am looking for a single formula that will aggregate data for a parent group with a one to many relationship. Imagine I have sales by employee and I have an employee to group mapping table. My goal is to create a table with sales by group without mapping the group to the sales by employee...

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