Return values with H lookup in a checklist

[Dougal2913]

[TABLE="width: 457"]
<colgroup><col><col><col span="4"></colgroup><tbody>[TR]
[TD]A B C

Error Code Doc 1 Doc 2
C010
C011 e
C012

The question I have is if columns B through K = "e" (meaning that document has an error) I want the value of the Doc # and the error code to be returned on a separate sheet.

Any help would be appreciated.
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[FDibbins]

Will there be more than 1 error per row?
maybe add a helper column to text for "e", give that a unique ID and pull that using INDEX/MATCH?
for instance, in L2...
=if(countif(B2:K2,"e")>1,L1+1,L1)
copied down
Then to pull those code...
=index(sheet1!A:A,match(rows($A$1:A1),sheet1!L:L,0))
copied down