Transposing and more

Hi Guys,
Can anyone help me with this ..
I got a few formulae from the microsoft site but i want to change them from checking columns of data to checking rows and then giving me the column ref rather than the row.
I am including a sample file as its easier to see rather than explain.
here are the two formulae

=IF(ISERROR(INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1)),2)),"",INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1)),2))

=SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1))

Id also like a similar error check in the second formula too if possible.
Ive tried transposing them but with no luck.
Many thanks in advance
Neil

When working with Arrays/Sumproduct avoid double evaluation at all costs as they are inefficient formulae in the first instance.

Using your sample:

Please Login or Register  to view this content.

Given you're calculating the Column in I there's no need to repeat the same array in H - simply use the value in I within an INDEX call to retrieve the actual value.

Regards the double evaluation error handler - you could use an IFERROR handler given XL2010 but to avoid calculating the Array unnecessarily in the first instance we add a pre-emptive COUNTIF test.