If function, search function To navigate path in server

[Jroldan148]

Hi!

I'm trying to create a logical argument in excel to recognize a specific letter and number combo in a cell and depending on the results, I want excel to link to the corresponding folder in my server.

For example:
I want Apple17 to locate the "Apple2017" file in the 2017 folder in my server,
I want Apple2015 to locate the "Apple2015" file in the 2015 folder in my server
and so on.

I believe the If and Search function would work, but I keep getting error messages and I'm not sure what I'm doing wrong. I'm a beginner at this so any advice would be helpful, thanks in advance!

 

[pbornemeier]

Will the input always start with Apple ?
With it always end with a 2- or 4-digit year?
Is there a starting directory for the server search? If not this could take a very long time.
What code/functions are you using?
What error messages are you getting.
What do you mean by "link"? Possibly just return a valid directory name?