My Sheet1:

A B C D
CA MN SD <=== row 1
John 100 200 500
Bill 300 400 600


My sheet2:

A

CA < row 1
John
100 <==== formula here in A3 :

=INDEX(Sheet1!$B$1:$D$3,MATCH(A1,Sheet1!$B$1:$D$1, 0),MATCH(A2,Sheet1!$A$1:$A$3))

HTH




"Buzz07" wrote:

This is the formula that I have been trying to get to work. It's obviously
not the answer. Any ideas?

=INDEX(StateEmployeeData!C:C,MATCH('ClientStatesOc cupied
'!A3&'ClientStatesOccupied
'!D2,StateEmployeeData!A:A&StateEmployeeData!B:B,0 ),3)

StateEmployeeData = Sheet 2 (data table)
ClientStatesOccupied = Sheet 1 (grid I'm wanting the info to go into.)

"Toppers" wrote:

=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.