View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HowardM HowardM is offline
external usenet poster
 
Posts: 4
Default Lookup assistance needed

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