HLookup with more than one lookup value

[ba4crm]

Hi,
I have a table in MS Excel 2002 like this:
Row 1 - Clerk (A,B,C)
Row 2 - Status (Approved,Cancel, Denied)
Row 3 - Count of Apps

The data looks like:
A A B B B
Approved Denied Approved Cancel Denied
[Count] [Count] [Count] [Count] [Count]

I would like the data to be displayed like:
Clerk A Clerk B Clerk C
Approved [Count] [Count] [Count]
Cancel [Count] [Count] [Count]
Denied [Count] [Count] [Count]

I know how to use HLookup - but only with one lookup value.
How can I do this?

 

[Lilliabeth]

Here is a thought:

Copy and paste as transposed, give it column labels, and make a pivot table.

 

[Lilliabeth]

Or, you could use Sumproduct, something like this:

=SUMPRODUCT((A1:E1="A")*(A2:E2="Approved")*(A3:E3))