Solved

need formula

Posted on 2013-11-14
4
251 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:pedwards3
  • 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:pedwards3
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:pedwards3
ID: 39649606
Thanks!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

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

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
My experience with Windows 10 over a one year period and suggestions for smooth operation
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

828 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