Need Suggestion on Correcting Value Not Available Error

[CARBOB]

The formula in column L searches for the value in column K and returns the value in column A on another worksheet that matches the value in column K, which should be 1. I am getting an Value Not Available Error. Any ideas on correcting the problem?

Excel Workbook
	K	L
36	013	###
37	118	###
38	477	###
39	179	###
40	789	###
DIGIT REPEATS

Excel 2007

Cell Formulas
Range	Formula
K36	=SMALL(B36:D36,1)&SMALL(B36:D36,2)&SMALL(B36:D36,3)
K37	=SMALL(B37:D37,1)&SMALL(B37:D37,2)&SMALL(B37:D37,3)
K38	=SMALL(B38:D38,1)&SMALL(B38:D38,2)&SMALL(B38:D38,3)
K39	=SMALL(B39:D39,1)&SMALL(B39:D39,2)&SMALL(B39:D39,3)
K40	=SMALL(B40:D40,1)&SMALL(B40:D40,2)&SMALL(B40:D40,3)
L36	=INDEX('MH-ML'!$A$6:$A$24,MATCH($K36,'MH-ML'!$B$6:$AE$24,0))
L37	=INDEX('MH-ML'!$A$6:$A$24,MATCH($K37,'MH-ML'!$B$6:$AE$24,0))
L38	=INDEX('MH-ML'!$A$6:$A$24,MATCH($K38,'MH-ML'!$B$6:$AE$24,0))
L39	=INDEX('MH-ML'!$A$6:$A$24,MATCH($K39,'MH-ML'!$B$6:$AE$24,0))
L40	=INDEX('MH-ML'!$A$6:$A$24,MATCH($K40,'MH-ML'!$B$6:$AE$24,0))

Excel Workbook
	A	B	C	D	E
14	-1	011	023	035	047
15	0	000	012	024	036
16	1	001	013	025	037
MH-ML

Excel 2007

 

[bschwartz]

Match only works if you're looking up one row or one column. You cannot look up a value in multiple rows/columns in the same match argument.

 

[CARBOB]

Match only works if you're looking up one row or one column. You cannot look up a value in multiple rows/columns in the same match argument.

any suggestions for a formula that would work, using multiple columns?

 

[CARBOB]

I redid the worksheet and entered the data into one column. Works now.