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

		Microsoft Office Forums > Microsoft Excel > Excel
Using a VLOOKUP - when 2 rows match criteria it returns the first value in the cel only how 2 change

FAQ

Thread Tools

Display Modes

10-28-2015, 01:32 AM

Pecoflyer

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

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

FYI the ">0" part can be skipped

=if(COUNTIFS(Dumps!A:A,Lookups!A3,Dumps!O:O,"Open" ),"Open","Closed")

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Tags

countifs, vlookup

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:32 AM.