Need formula help!

[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

 

[Don Guillett]

I think I would make a list
a
b
c
d
and use FINDNEXT to put the value in the next available column next to the
letter.