return multiple corresponding values horizontally using multiple lookup values (with duplicates)

[mangotango]

Hi All, I'm looking for some guidance on a lookup question that I just can't seem to find a solution for. I originally posted this to a thread called 'Return multiple corresponding values using multiple lookup values' but I was not able to get what I needed from it so I've reposted a new thread here. The following is a sample of the dataset:
Excel 2010

	A	B	C
1	Record ID	Sketch #	Sum of Mango Accepted
2	511010027	3223	7
3	511010033	322	6
4	511020065	8823	9
5	511020065	8842	16
6	511020065	8843	8
7	511020077	8845	11
8	511020086	3168	5

<tbody>
</tbody>

Sheet2
​

Effectively, I want to lookup the values in Column A and return the corresponding values in Columns B and C horizontally, following this format:

recordID

sketch#1

mangoaccepted1

sketch#2

mangoaccepted2

sketch#3

mangoaccepted3

<tbody>
</tbody>

I've tried the array: =INDEX($B$2:$B$8, SMALL(IF($A2=$A$2:$B$8, ROW($A$2:$A$8)-MIN(ROW($A$2:$A$8))+1, ""), COLUMN(A1))) which will onlyreturn the <vb_highlight>values</vb_highlight> from Column B.
Excel 2010

	A	B	C	D	E	F	G
11	recordId_key	sketch#1	mangoaccepted1	sketch#2	mangoaccepted2	sketch#3	mangoaccepted3
12	511010027	3223	#NUM!
13	511010033	322	#NUM!
14	511020065	8823	8842	8843	#NUM!
15	511020065	8823	8842	8843	#NUM!
16	511020065	8823	8842	8843	#NUM!
17	511020077	8845	#NUM!
18	511020086	3168	#NUM!

<tbody>
</tbody>

Sheet2

Array Formulas Cell Formula D14 {=INDEX($B$2:$B$8, SMALL(IF($A4=$A$2:$B$8, ROW($A$2:$A$8)-MIN(ROW($A$2:$A$8))+1, ""), COLUMN(C3)))} E14 {=INDEX($B$2:$B$8, SMALL(IF($A4=$A$2:$B$8, ROW($A$2:$A$8)-MIN(ROW($A$2:$A$8))+1, ""), COLUMN(D3)))} D15 {=INDEX($B$2:$B$8, SMALL(IF($A5=$A$2:$B$8, ROW($A$2:$A$8)-MIN(ROW($A$2:$A$8))+1, ""), COLUMN(C4)))} E15 {=INDEX($B$2:$B$8, SMALL(IF($A5=$A$2:$B$8, ROW($A$2:$A$8)-MIN(ROW($A$2:$A$8))+1, ""), COLUMN(D4)))} D16 {=INDEX($B$2:$B$8, SMALL(IF($A6=$A$2:$B$8, ROW($A$2:$A$8)-MIN(ROW($A$2:$A$8))+1, ""), COLUMN(C5)))} E16 {=INDEX($B$2:$B$8, SMALL(IF($A6=$A$2:$B$8, ROW($A$2:$A$8)-MIN(ROW($A$2:$A$8))+1, ""), COLUMN(D5)))} B12 {=INDEX($B$2:$B$8, SMALL(IF($A2=$A$2:$B$8, ROW($A$2:$A$8)-MIN(ROW($A$2:$A$8))+1, ""), COLUMN(A1)))} C12 {=INDEX($B$2:$B$8, SMALL(IF($A2=$A$2:$B$8, ROW($A$2:$A$8)-MIN(ROW($A$2:$A$8))+1, ""), COLUMN(B1)))} B13 {=INDEX($B$2:$B$8, SMALL(IF($A3=$A$2:$B$8, ROW($A$2:$A$8)-MIN(ROW($A$2:$A$8))+1, ""), COLUMN(A2)))} C13 {=INDEX($B$2:$B$8, SMALL(IF($A3=$A$2:$B$8, ROW($A$2:$A$8)-MIN(ROW($A$2:$A$8))+1, ""), COLUMN(B2)))} B14 {=INDEX($B$2:$B$8, SMALL(IF($A4=$A$2:$B$8, ROW($A$2:$A$8)-MIN(ROW($A$2:$A$8))+1, ""), COLUMN(A3)))} C14 {=INDEX($B$2:$B$8, SMALL(IF($A4=$A$2:$B$8, ROW($A$2:$A$8)-MIN(ROW($A$2:$A$8))+1, ""), COLUMN(B3)))} B15 {=INDEX($B$2:$B$8, SMALL(IF($A5=$A$2:$B$8, ROW($A$2:$A$8)-MIN(ROW($A$2:$A$8))+1, ""), COLUMN(A4)))} C15 {=INDEX($B$2:$B$8, SMALL(IF($A5=$A$2:$B$8, ROW($A$2:$A$8)-MIN(ROW($A$2:$A$8))+1, ""), COLUMN(B4)))} B16 {=INDEX($B$2:$B$8, SMALL(IF($A6=$A$2:$B$8, ROW($A$2:$A$8)-MIN(ROW($A$2:$A$8))+1, ""), COLUMN(A5)))} C16 {=INDEX($B$2:$B$8, SMALL(IF($A6=$A$2:$B$8, ROW($A$2:$A$8)-MIN(ROW($A$2:$A$8))+1, ""), COLUMN(B5)))} B17 {=INDEX($B$2:$B$8, SMALL(IF($A7=$A$2:$B$8, ROW($A$2:$A$8)-MIN(ROW($A$2:$A$8))+1, ""), COLUMN(A6)))} C17 {=INDEX($B$2:$B$8, SMALL(IF($A7=$A$2:$B$8, ROW($A$2:$A$8)-MIN(ROW($A$2:$A$8))+1, ""), COLUMN(B6)))} B18 {=INDEX($B$2:$B$8, SMALL(IF($A8=$A$2:$B$8, ROW($A$2:$A$8)-MIN(ROW($A$2:$A$8))+1, ""), COLUMN(A7)))} C18 {=INDEX($B$2:$B$8, SMALL(IF($A8=$A$2:$B$8, ROW($A$2:$A$8)-MIN(ROW($A$2:$A$8))+1, ""), COLUMN(B7)))} <tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>

I've tried the array: =INDEX($A$2:$C$8, SMALL(IF($A2=$A$2:$A$8, ROW($A$2:$A$8)-MIN(ROW($A$2:$A$8))+1, ""), ROW(A1)),COLUMN(A1)) which will return the <vb_highlight>values</vb_highlight> from both Columns B and C but will not allow me to copy+paste (or drag) the formula down Column A.
Excel 2010

	A	B	C	D	E	F	G
20	recordId_key	sketch#1	mangoaccepted1	sketch#2	mangoaccepted2	sketch#3	mangoaccepted3
21	511010027	3223	7	#REF!
22	#NUM!
23

<tbody>
</tbody>

Sheet2

Array Formulas Cell Formula A21 {=INDEX($A$2:$C$8, SMALL(IF($A2=$A$2:$A$8, ROW($A$2:$A$8)-MIN(ROW($A$2:$A$8))+1, ""), ROW(A1)),COLUMN(A1))} B21 {=INDEX($A$2:$C$8, SMALL(IF($A2=$A$2:$A$8, ROW($A$2:$A$8)-MIN(ROW($A$2:$A$8))+1, ""), ROW(B1)),COLUMN(B1))} C21 {=INDEX($A$2:$C$8, SMALL(IF($A2=$A$2:$A$8, ROW($A$2:$A$8)-MIN(ROW($A$2:$A$8))+1, ""), ROW(C1)),COLUMN(C1))} D21 {=INDEX($A$2:$C$8, SMALL(IF($A2=$A$2:$A$8, ROW($A$2:$A$8)-MIN(ROW($A$2:$A$8))+1, ""), ROW(D1)),COLUMN(D1))} A22 {=INDEX($A$2:$C$8, SMALL(IF($A3=$A$2:$A$8, ROW($A$2:$A$8)-MIN(ROW($A$2:$A$8))+1, ""), ROW(A2)),COLUMN(A2))} <tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>

I'm sure I'm missing just one piece of the puzzle but any help will be greatly appreciated...thanks!
​