Thank you so much. Works like a charm. Can you help me understand what the
+1 represents?

"Smoking" wrote:

For example, if you put Center2 in A13, Client4 in B13 and Feb in C13 then
put the following formula in Cell A15:
=INDEX($A$1:$E$11,(MATCH(A13&B13,A2:A11&B2:B11,0)+ 1),MATCH(C13,A1:E1,0)).
Please entre as arraye formula. and you will get different lookup value if
you change any criteria in cell A13 B13 or C13.

"HowardM" wrote:

Thank you for your reply.

I also need it to match the appropriate month which is also a variable as
well. Not sure if that is clear....if the formula that is looking up the
value is in a column that is entitled "Jan", then I need it to find the value
for Center 2, Client 4 that is in the Jan Column. If the lookup formula is
in a column entitled "Mar" then it needs to lookup Center 2, Client 4 that is
in the Mar column. How does that change the formula?

"Ms-Exl-Learner" wrote:

Copy and paste the below formula.

=INDEX($E$2:$E$11,MATCH(1,($A$2:$A$11="CENTER2")*( $B$2:$B$11="CLIENT 4")))

After pasting the formula give F2 and press Cntrl+Shift+Enter since it is an
array formula.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"HowardM" wrote:

Same question as to how to complete lookup but I have changed to table to
remove the issue of it being in a pivot table. Revised table below.

Any help would be appreciated.

A B C D E
1 Center Client Jan Feb Mar

2 Center1 Client 1 0 3 0
3 Center1 Client 2 131 108 107
4 Center1 Client 3 4 0 0
5 Center1 Client 4 25 24 24
6 Center1 Client 5 1 0 7
7 Center2 Client 1 0 0 0
8 Center2 Client 2 20 4 4
9 Center2 Client 3 0 1 6
10 Center2 Client 4 36 32 48
11 Center2 Client 5 11 1 2