Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# Index/Match with Multiple Criteria

Posted on 2016-11-30
Medium Priority
67 Views
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
Question by:awesomejohn19
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 33

Accepted Solution

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

ID: 41908842
Thanks
0

## Featured Post

Question has a verified solution.

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

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
###### Suggested Courses
Course of the Month11 days, 1 hour left to enroll