Hi all,

I have two worksheets. One which has a list of properties, the other has a list of the same properties, but as their Autocad drawing file names.

I believe that not all the properties have drawings, so I'm trying to run a search that displays which properties do. However due to the drawing name (e.g. Hoddesden GF As Fixed (29245) MVS.dwg) being different to the property name (e.g. Hoddesden) I am not entirely sure how I go about doing this.

If it's of any use, the property name is always the first thing to appear before the drawing extension details.

Can anyone suggest a solution? I've tried a couple of IF(VLOOKUP)-type functions but always get stumped when it comes to getting Excel to ignore everything after the property name.

Any help greatly appreciated.

TIA,

SamuelT