Solved

Index/Match with Multiple Criteria

Posted on 2016-11-30
2
26 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 32

Accepted Solution

by:
Rob Henson earned 500 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

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Suggested Solutions

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvieā€¦
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

803 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