Formula Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

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$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.
 
=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))

--
HTH

Bob

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

This worked great.

Bob Phillips said:
=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))

--
HTH

Bob

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

BoRed79 said:
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.
Click to expand...
Click to expand...
 
Back
Top