Need help to modify a mid/index formula-need text instead of error #N/A

Originally Posted by FDibbins

you uploaded a file with a .xlsx extension. that file can only come from excel 2007 or later. was that file created on another PC, or given to you by someone???

the following formula will show an "epmty" cell, using 2003...

=IF(ISERROR(MID(INDEX($C$25:$C$48,MATCH("PREC",I$25:I$48,0)),2,2)),"",MID(INDEX($C$25:$C$48,MATCH("PREC",I$25:I$48,0)),2,2))

Thank you so much for your help...that works perfectly! I have both 2003 and 2007 at work so I must have created it in 2007, but I use 2003 at home.