Solved

need formula

Posted on 2013-11-14
4
268 Views
Last Modified: 2013-11-14
want to write a formula with "hypothetical" requirement of two separate workbooks(i've provide two tabs in my example) where I can write a formula matching a row with (part;serial; & location).  If a match write "text" of correct, if wrong write "text" of incorrect.

Any advice?
Excel-formula-1.xls
0
Comment
Question by:Pete Edwards
[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
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 23

Expert Comment

by:NBVC
ID: 39648920
In this sample, what exactly should be in the yellow cell as a result?
0
 

Author Comment

by:Pete Edwards
ID: 39648989
I want to match both tabs with serial, location, part and when it audits that criteria, if a "match" which in this example will not be, I want to say correct, if not a "match" to say incorrect.

Hope this helps.
0
 
LVL 23

Accepted Solution

by:
NBVC earned 400 total points
ID: 39649016
Ok try:

=IF(COUNTIFS('tag list'!A:A,A2,'tag list'!B:B,B2,'tag list'!C:C,C2),"Correct","Incorrect")
0
 

Author Closing Comment

by:Pete Edwards
ID: 39649606
Thanks!
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

623 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