Formula Error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BoRed79 - 16 Jul 2007 16:40 GMT

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$13:Data!$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.

Reply to this Message

Bob Phillips - 16 Jul 2007 17:12 GMT

=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$13:Data!$A$35,0))

Signature

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
[quoted text clipped - 13 lines]
>
> Thanks.

Reply to this Message

BoRed79 - 17 Jul 2007 08:14 GMT

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$13:Data!$A$35,0))
>
[quoted text clipped - 15 lines]
> >
> > Thanks.

Reply to this Message

Rate this thread: