View Single Post
 
Old 10-27-2015, 07:27 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Here's one way...

Code:
=if(COUNTIFS('Latest SQ01 Dumps'!A:A,'Cost Data Sheet Lookup Table'!A3,'Latest SQ01 Dumps'!O:O,"Open")>0,"Open","Closed")
A bit of creative criticism, I would rename your tabs to something more concise ideally without spaces. This will make your formulas a bit more aesthetic. For example, if your tabs were Validation, Dumps, and Lookups, the formula then would be:

Code:
=if(COUNTIFS(Dumps!A:A,Lookups!A3,Dumps!O:O,"Open")>0,"Open","Closed")
Reply With Quote