Solved

Index/Match with Multiple Criteria

Posted on 2016-11-30
2
14 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 31

Accepted Solution

by:
Rob Henson earned 500 total points
Comment Utility
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
Comment Utility
Thanks
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

744 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now