Hi all,

I'm currently using the below formula to check if a project name
appears in another spreadsheet:

=IF(VLOOKUP(A4,'Retail Tracker 3.3.xls'!twooffive,1,FALSE)=D4,"Y","")

I have a slight problem though as a number of projects names have extra
words either side of them - thus making the VLOOKUP obsolete. For
example - in the documents with the above formula a project appears as
'Newark-On-Trent', however in the file 'Retail Tracker 3.3.xls, it
might appear as 'Newark-on-Trent Broad Street' or even 'Broad Street
Newark-on-Trent'.

Can anyone suggest what I need to do to my current formula (or another
formula altogether) that would allow for these differences in name, but
still pick it up if (again, for example) 'Newark-On-Trent' appears in
the project name.

Hope that's clear.

TIA,

SamuelT


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

add "*"

=IF(VLOOKUP(A4&"*",'Retail Tracker 3.3.xls'!twooffive,1,FALSE)=D4,"Y","")


"SamuelT" wrote:


Hi all,

I'm currently using the below formula to check if a project name
appears in another spreadsheet:

=IF(VLOOKUP(A4,'Retail Tracker 3.3.xls'!twooffive,1,FALSE)=D4,"Y","")

I have a slight problem though as a number of projects names have extra
words either side of them - thus making the VLOOKUP obsolete. For
example - in the documents with the above formula a project appears as
'Newark-On-Trent', however in the file 'Retail Tracker 3.3.xls, it
might appear as 'Newark-on-Trent Broad Street' or even 'Broad Street
Newark-on-Trent'.

Can anyone suggest what I need to do to my current formula (or another
formula altogether) that would allow for these differences in name, but
still pick it up if (again, for example) 'Newark-On-Trent' appears in
the project name.

Hope that's clear.

TIA,

SamuelT


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

Many thanks Muhammed.


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