index match array

  1. H

    Not sure where to start...

    Hi, I'm hoping someone here can help me. I am trying to return the cells that have a value in column A if R1 matches with the corresponding table header. I think an array index match formula is the way to go but I can't seem to get my head around it.
  2. G

    Sum specific cells in column based on multiple row criteria

    I cannot find an answer to this anywhere, so hoping you can help! I have a list of ref IDs in Column A which may or may not be unique (eg. 1, 1, 1, 2, 3, 3, 4, 4 ,4 ,4...etc). I need to be able to find the last instance of EACH of these ref IDs in Column A and sum the associated cell values in a...
  3. L

    SUMIFS/INDEX-MATCH based on criteria in 2 rows and 1 column

    I'm using Google Sheets. In another tab, I'm trying to match in the values (in the white part of the table) based on the three criteria. So for example, I'm wanting to match in the 0.2856... for criteria: Member #1, 1, A.
  4. L

    SUMIFS with 2 row and 1 column Google sheets

    I'm trying to match in a value (either using SUMIFS or INDEX MATCH) based on multiple criteria (two rows, one column).
  5. C

    Index match first value that contains "@"

    Hey, First time posting. I have a data set with duplicate account keys and values in the form of email addresses. I need to create a consolidated data set that has only one account key and a corresponding email value. My issue is this -- some of the duplicate account keys have blanks or "old...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top