|
|
|
Author |
Message |
PeterCohan
|
Posted: Mon Aug 21 08:28:02 CDT 2006 |
Top |
Excel Misc >> Unidentical VLOOKUP
Hi all,
I'm currently using the below formula to check if a project nam
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 extr
words either side of them - thus making the VLOOKUP obsolete. Fo
example - in the documents with the above formula a project appears a
'Newark-On-Trent', however in the file 'Retail Tracker 3.3.xls, i
might appear as 'Newark-on-Trent Broad Street' or even 'Broad Stree
Newark-on-Trent'.
Can anyone suggest what I need to do to my current formula (or anothe
formula altogether) that would allow for these differences in name, bu
still pick it up if (again, for example) 'Newark-On-Trent' appears i
the project name.
Hope that's clear.
TIA,
Samuel
--
Samuel
-----------------------------------------------------------------------
SamuelT's Profile: http://www.hide-link.com/ ;userid=2750
View this thread: http://www.hide-link.com/
Excel376
|
|
|
|
|
MuhammedRafeekM
|
Posted: Mon Aug 21 08:28:02 CDT 2006 |
Top |
Excel Misc >> Unidentical VLOOKUP
add "*"
=IF(VLOOKUP(A4&"*",'Retail Tracker 3.3.xls'!twooffive,1,FALSE)=D4,"Y","")
>
> 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?action=getinfo&userid=27501
> View this thread: http://www.excelforum.com/showthread.php?threadid=573744
>
>
|
|
|
|
|
SamuelT
|
Posted: Mon Aug 21 08:43:37 CDT 2006 |
Top |
|
|
|
|
|