Using a VLOOKUP - when 2 rows match criteria it returns the first value in the cel only how 2 change

gebobs · #2 10-27-2015, 07:27 AM

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")

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count unique values that match 2 or more criteria	caeiro01	Excel	1	10-25-2015 02:34 AM
Vlookup and Match	ExcelVlookup	Excel	4	06-22-2015 01:42 AM
Vlookup returns inconsistent results	Jhnsnkth527	Excel	0	04-16-2015 12:36 PM
vlookup or match	uhlersa	Excel	2	12-04-2012 12:35 AM
Vlookup or Index/Match - Multiple Criteria	ruci1225	Excel	1	01-15-2012 07:31 AM