Solved

need formula

Posted on 2013-11-14
4
245 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

This article will show you how to use shortcut menus in the Access run-time environment.
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

773 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