D
Don
I run across this problem many times and know there must be an "easy button"
to do this.
I have a pivot table cumulating data and wish to return more than one field
when doing a look up of the primary value.
An example would be Pivot 1
A B C D
1 w 10 11 12
2 w 20 21 22
3 w 30 31 32
4 x 40 41 42
5 y 50 51 52
On Sheet 1, I would like to return all values that match "w", bringing along
all three rows and columns.
A B C D
1 w
2
3
4
In this case, the return values would be
B1 = 10
B2 = 20
B3 = 30
C1 = 11
C2 = 21
C3 = 31
D1 = 12
D2 = 22
D3 = 32
VLook up does not cut it and I assume there is some other function to call.
to do this.
I have a pivot table cumulating data and wish to return more than one field
when doing a look up of the primary value.
An example would be Pivot 1
A B C D
1 w 10 11 12
2 w 20 21 22
3 w 30 31 32
4 x 40 41 42
5 y 50 51 52
On Sheet 1, I would like to return all values that match "w", bringing along
all three rows and columns.
A B C D
1 w
2
3
4
In this case, the return values would be
B1 = 10
B2 = 20
B3 = 30
C1 = 11
C2 = 21
C3 = 31
D1 = 12
D2 = 22
D3 = 32
VLook up does not cut it and I assume there is some other function to call.