Vlookup multiple criteria
If you just want a count of the rows that match your criteria, then:
=SUMPRODUCT(--(A1:A20="Error Summary"),--(B1:B20="Loan
Type"),--(C1:C20="Type Code"))
"Robert_L_Ross" wrote in message
...
Here's my problem - I have the following table:
Error Summary Count Source Type Code Loan Type
Blank Text 6 C CL
Consolidation 7 C CL
Unique ID 3 C CL
Interest Rate 4 C CL
I need to to a vlookup where I match Error Summary AND Loan Type AND
Source
Type Code, then return the Count.
Is this possible?
|