?
Solved

Index/Match with Multiple Criteria

Posted on 2016-11-30
2
Medium Priority
?
77 Views
Last Modified: 2016-12-01
Here are the inputs

2 Worksheets , lets say a and be

Look for "C11 on Sheet B" in "Sheet A Range A44:A73"
Look for "A18 on Sheet B" in "Sheet A Range N44:N73"
When the match is found the formula Should return the matching value om Sheet A Column D
0
Comment
Question by:awesomejohn19
2 Comments
 
LVL 35

Accepted Solution

by:
Rob Henson earned 2000 total points
ID: 41908375
Is the value in column D numeric?

If so you may be able to use the SUMIFS function:

=SUMIFS(SheetA!D44:D73,SheetA!A44:A73,C11,SheetA!N44:N73,A18)

Thanks
Rob H
0
 

Author Closing Comment

by:awesomejohn19
ID: 41908842
Thanks
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question