Return value in C where A and B match on both sheets.

Posted on 2014-12-31
Medium Priority
Last Modified: 2014-12-31

I prematurely accepted an answer for a problem to return the value in C of sheet1 where A and B match on two different sheets. The following formula will return a value but not from the row that has the match.


Attached is an example sheet.


Question by:swjtx99
LVL 43

Accepted Solution

Saqib Husain, Syed earned 2000 total points
ID: 40525892
Try this array formula

=SUM(IF((A2='Sheet1 PL'!$A$1:$A$10)*(B2='Sheet1 PL'!$B$1:$B$10),('Sheet1 PL'!$C$1:$C$10)))

Author Closing Comment

ID: 40525906
Thanks Saqib,


Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

624 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