H
HBF
In Chart A my columns contain this:
Col A Col B Col C Col D
6/2 6/9 6/16
A 1
D 3
C 3
D 4
B 2
A 2
C 4
B 3
What formula would I use to get the above information to display i
Chart B?
Col A Col B Col C Col D
6/2 6/9 6/16
A 1 2
B 2 3
C 3 4
D 3 4
I tried to use a 2 dimensional vlookup
=VLOOKUP(A2,’Chart A'!A19,MATCH(B1,’Chart A'!A11,0),FALSE)
The problem is that this only returns the first value
Col A Col B Col C Col D
6/2 6/9 6/16
A 1
D 3
C 3
D 4
B 2
A 2
C 4
B 3
What formula would I use to get the above information to display i
Chart B?
Col A Col B Col C Col D
6/2 6/9 6/16
A 1 2
B 2 3
C 3 4
D 3 4
I tried to use a 2 dimensional vlookup
=VLOOKUP(A2,’Chart A'!A19,MATCH(B1,’Chart A'!A11,0),FALSE)
The problem is that this only returns the first value