Multiple IF(FIND functions

[senorsmith3]

Hi I am trying to make filling out a sheet I need to do daily a little bit easier by having a formula that searches a specific cell for a word (location name in this case), and have it input the time I specify into another cell. I already have it set so that the location name is put in when I name the tab for said location. I am trying to make a chain so that whatever location I put in it will put the times I specify.

Maybe this example will help
first off I am using this formula to name a cell based on the tabs name:
=RIGHT(CELL("filename",$A$1),LEN(CELL("filename",$A$1))-FIND("]",CELL("filename",$A$1),1))
in the first tab I name is "Kiso nishi", in cell A63

next in cell e-k65 i put this formula in
=IF(FIND("Kiso",$A$63,1),"Start time　9：10 Finish time 9：35-40　Length 25-30min", IF(FIND("Kosugi",$A$63,1), "Start Time 2:45 Finish Time 3:15 Length 30 min"))
the second half of the formula is the name of another location I visit, since the first part of the formula is true, it works beautifully

However when I use this exact same formula on the next tab, which is labeled Musashi Kosugi, it turns up with #VALUE!. Any ideas why?

What I am requesting is I want a formula similar to this idea, but I want it to work for all 11 locations I visit. I have tried concatenate but am not too sure how it works.
I would like this formula to be a universal one so I can put it in any of the tabs and it will show the desired result.

Any help is appreciated and thank you in advance!

[ragulduy]

When the cell does not contain Kiso the find function will return an error, which excel does not evaluate to true or false, you probably want something like
=IF(NOT(ISERROR(FIND("Kiso",$A$63,1))),"Start time　9：10 Finish time 9：35-40　Length 25-30min", IF(NOT(ISERROR(FIND("Kosugi",$A$63,1))), "Start Time 2:45 Finish Time 3:15 Length 30 min"))
instead

[Pepe Le Mokko]

Precede the FIND function with "ISNUMBER"
=IF(ISNUMBER(FIND( ...

[senorsmith3]

Awesome! Thank you for the quick response! The problem with the 2nd tab has been fixed!!

Now about the next part, I would like to make this formula with 11 locations in it, should I just used =CONCATENATE(IF(NOT(ISERROR(FIND("Kiso",$A$63,1))),"Start time 9:10 Finish time 9:35-40 Length 25-30min"), IF(NOT(ISERROR(FIND("Kosugi",$A$63,1))),"Start Time 2:45 Finish Time 3:15 Length 30 min"), IF(NOT(ISERROR(FIND("location C",$A$63,1))),"Start time 9:45 Finish time 9:50 Length 5min"), etc?