I'm guessing how your table is setup.

Assuming that the clients are the same and in the same sequence for each
center.

Lookup values:

G1 = Center1
H1 = Client 3
I1 = Mar

=INDEX(C2:E13,MATCH(G1,A2:A12,0)+MATCH(H1,B2:B6,0)-1,MATCH(I1,C1:E1,0))

--
Biff
Microsoft Excel MVP


"HowardM" wrote in message
...
I have a pivot table of data that I would like to complete a lookup on.
The
data is in a pivot table because I need some of the data grouped before I
complete the lookup on it. I am trying to complete a lookup that first
finds
the Center then looks for the Client. Once the correct Center and Client
are
found, then I want it to look up the Month and return the data point. So
if
I have it lookup Center2, Client4 for Mar., it would return the value of
48.
See example table below:

A B C D E
1 Center Client Jan Feb Mar

2 Center1 Client 1 22 3 25
3 Client 2 131 108 107
4 Client 3 4 0 0
5 Client 4 25 24 24
6 Client 5 1 0 7
7 Center1 Total 161 135 138
8 Center2 Client 1 0 0 0
9 Client 2 20 4 4
10 Client 3 0 1 6
11 Client 4 36 32 48
12 Client 5 11 1 2
13 Center2 Total 67 38 60

Any ideas on how to set up the lookup would be greatly appreciated.