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


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=566659