Need some input from excel expert's.

I need to make a script in excel that
would search and insert location(address) of the file in column.

Such as if I insert file name : xyz (to
be searched) in A column it would generate the link in B column

Something like search function in
windows.

Is this possible in excel?

Thanks.