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

[SerraAngel]

Hi all,
I have this formula in row 14 (see below)...what this does is if I type the word "PREC" anywhere between I25 and I48 then cell I14 will populate with the correct initials. However, sometimes I don't need the word "PREC" in every column and when I delete the word "PREC" the cells in row 14 get an error #N/A. Is there a way to modify this formula so the cells in row 14 will populate with "0 RES" when I do not need "PREC" in the column instead of the error message?

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

Thanks

[rossg]

=iferror(mid(index($c$25:$c$48,match("prec",i$25:i$48,0)),2,2),"0 res")

[dilipandey]

Hi Serra,

Suggest you to change the thread title to reflect the query you are asking - may be you can mention formula name / logic issue in title line. thanks.

Regards,
DILIPandey
<click on below * if this helps>

[SerraAngel]

=iferror(mid(index($c$25:$c$48,match("prec",i$25:i$48,0)),2,2),"0 res")

Sorry that formula is giving me an error message

[SerraAngel]

Hi Serra,

Suggest you to change the thread title to reflect the query you are asking - may be you can mention formula name / logic issue in title line. thanks.

Regards,
DILIPandey
<click on below * if this helps>

Can you tell me how to change the title of the thread?

[FDibbins]

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[rossg]

did you paste that formula into "I14" ?

it works fine in my doc, even when copied off the forum..

[FDibbins]

rossg...Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests - note that this includes requests by senior members as well, if you are unclear about their request or instruction then send a private message to them asking for help. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc

[SerraAngel]

did you paste that formula into "I14" ?

it works fine in my doc, even when copied off the forum..

I am using excel 2003. When I open the file you posted the formula doesn't work.

[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))

[SerraAngel]

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.