array lookup table

  1. A

    Summing multiple array lookups within one cell

    Hello Excel friends, I'm trying to sum a multiple array lookup without much success. I've read through many threads on this forum and googled furiously, but just can't quite seem to make it work. I have a table of lookup values, I'm showing 4 pairs here, which represent start & end dates. In...
  2. N

    Value of one cell returns a list from another sheet?

    Hi everyone, I've been trying to figure this out and think I may need to use Arrays somehow, but I am not sure. Here's the deal: I have a table of employees as follows: Employee names in the left hand column. Across the top are column headings that are Skillsets they may have (Basket Weaving...

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