View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default 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?