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