Enter 4 digit code - Excel find folder with code on P: drive and paste folder name into cell

[fegis]

Hi all my first post!


I have Office 365 and would like to create an autofill code please. Not sure if this is possible.

I would like to enter a 4 digit code into A4, have excel take that code, check the folders in the P:\ (network drive) Copy the corresponding folder that contains the 4 digit code then paste it into A5. eg:

User enters to A4 = 8818

Excel finds:

P:\8818 123-125 made up address, Melbourne

Excel to fill in 

A5 = 123-125 made up address, Melbourne

Many thanks in advance!
Fegis

 

[fegis]

sorry had a think, can i please change the output to the full folder name, no need to drop off the input. eg:

User enters to A4 = 8818

Excel finds:

P:\8818 123-125 made up address, Melbourne

Excel to fill in

A5 = 8818 123-125 made up address, Melbourne

Thank you