Function to search folder and return exact filename

[travisc]

Ex;
Cell A1 : "C184A"
Cell A2 : =FINDSPC(A1,[Top/Bottom/Left/Right])

Cell A2 would be the path+filename to the file that's found. It needs to search a predefined folder (lets call it C:\test) for "*C184A*Top*" or "*C184A*Bottom*" etc...

I've searched, but can't find any results that are very similar. :/

Thanks in advance for any help

 

[travisc]

scratch this. Figured out an alternative using Name Manager and the INDEX function. Thanks guys