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 in
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'!A1:D9,MATCH(B1,’Chart A'!A1:D1,0),FALSE)

The problem is that this only returns the first value.


--
HBF
------------------------------------------------------------------------
HBF's Profile: http://www.excelforum.com/member.php...o&userid=34019
View this thread: http://www.excelforum.com/showthread...hreadid=552224