Formula to Return Blank

[CARBOB]

Can the forumula in column J436, be changed to return a blank, if the value is not found?

Excel Workbook
	D	E	F	G	H	I	J	K
435	6	3	6	0625	636	366	170	TRUE
436	2	4	4	0624	244	244	#N/A	#N/A
Descending

Excel 2007

Cell Formulas
Range	Formula
G435	=A435
G436	=A436
H435	=VALUE(D435&E435&F435)
H436	=VALUE(D436&E436&F436)
I435	=VALUE(SMALL(D435:F435,1)&SMALL(D435:F435,2)&SMALL(D435:F435,3))
I436	=VALUE(SMALL(D436:F436,1)&SMALL(D436:F436,2)&SMALL(D436:F436,3))
J435	=MATCH(I435,I436:I$5457,0)
J436	=MATCH(I436,I437:I$5457,0)
K435	=LEFT(J435)="1"
K436	=LEFT(J436)="1"""

 

[Andrew Poulsom]

Maybe try:

=IF(COUNTIF(I437:I$5457,I436),MATCH(I436,I437:I$5457,0),"")

 

[Peter_SSs]

Try
=IFERROR(MATCH(I436,I437:I$5457,0),"")

 

[bolo]

Try
=IFERROR(MATCH(I436,I437:I$5457,0),"")

Only in excel 2007 + though!

 

[CARBOB]

That worked, thanks!!

 

[Peter_SSs]

Only in excel 2007 + though!

That's what the OP's screen shot says they are using.