Formula Error

[Guest]

I am using the following formula, which works really well and brings back the
data that I want it to:

=INDEX(Data!$B$13:$B$35,MATCH(MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-5),Data!$A$13ata!$A$35,0))

However, when I close the file and reopen it, an error #N/A comes up in the
cell.

Once I click in the formula and hit return the proper value comes back in.

Is there any way to stop this error keep coming up and keep the proper value
in it.

Thanks.

 

[Bob Phillips]

=INDEX(Data!$B$13:$B$35,MATCH(MID(CELL("filename",A1),SEARCH("[",CELL("filename",A1))+1,SEARCH("]",CELL("filename",A1))-SEARCH("[",CELL("filename",A1))-5),Data!$A$13ata!$A$35,0))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Thanks.

This worked great.

=INDEX(Data!$B$13:$B$35,MATCH(MID(CELL("filename",A1),SEARCH("[",CELL("filename",A1))+1,SEARCH("]",CELL("filename",A1))-SEARCH("[",CELL("filename",A1))-5),Data!$A$13ata!$A$35,0))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

I am using the following formula, which works really well and brings back
the
data that I want it to:

=INDEX(Data!$B$13:$B$35,MATCH(MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-5),Data!$A$13ata!$A$35,0))

However, when I close the file and reopen it, an error #N/A comes up in
the
cell.

Once I click in the formula and hit return the proper value comes back in.

Is there any way to stop this error keep coming up and keep the proper
value
in it.

Thanks.