Thread: Vlookup for 2 sets of Criteria (or do I need to use something else
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default Vlookup for 2 sets of Criteria (or do I need to use something else
=INDEX(F1:F100,MATCH(1,(A1:A100="Custname")*(D1:D1 00="State"),0))

Replace Custname and State by text or Cells containing your values

Enter with Ctrl+Shift+Enter

OR

=SUMPRODUCT(--(A1:A100="Custname"),--(D1:D100="State"),F1:F100)

just Enter.

"Buzz07" wrote:

I'm trying to do a vlookup with 2 sets of criteria. For example: I want to
look up a customer name in column A and the customer state in column D, if
they both match then bring back the # of employees per state in column F.
Reply With QuoteReply With Quote