multiple returns

  1. I

    Vlookup with sum and multiple returns

    Hello. I have workbook that lists badge numbers in column A. Hours in column H. I want to be able to add up all the hours by badge id. The problem is the a badge number can appear multiple times. So a regular Vlookup will not work. I have also tried a sumif formula. This adds them up however, it...
  2. O

    Lookup multiple values with multiple criteria, fill horizontally by header category

    Hello friends, a long time lurker-first time poster. This place has saved my *** on multiple occasions. Unfortunately, I have now spent days looking for a solution without much luck and felt compelled to ask my first question. The problem at hand is this. I have a list of employees (by ID) and...
    • ophizer
    • Thread
    • column array index-match multiple array multiple returns mutiple criteria
    • Replies: 4
    • Forum: Excel Questions
  3. R

    Use Index Match to fill in columns Sheet 1 based on data in Sheet 2

    I have Sheet 1 with an account number in column a and column B-Y are different products that each account may own. I would like to have the sheet filled out as seen below. I think I will be able to fill in the X's using Index Match. <tbody> Account# B C D E F G H I J K L M N O P Q R S T U V W...

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