Search whole word in string

[Deepak.sharma]

Hello All,

I need to search whole text either in the cell or if possible within a range.
I have two lists.

ListA
---------
Ask4 Internet Services
Abc consulting services
Chelsea Football Club
Lloyds Bank


ListB
---------
Internet
Abc
Ask
Lloyd



Now I need to find the words in ListB into ListA
So if I search for "Internet" it should give me 1st record.
but if I search for Ask it should not give any record.

I tried, "find", "search", "instr" but they all give me 1st record when I search for "Ask"

Please help.

Thanks
Deepak

[NBVC]

Assuming List A is in A1:A4 and List 2 is in F1:F4, then in G1 try:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER not just ENTER and copy down.

[alansidman]

You could use the Find Icon on your Ribbon/Menu. Control +F will open the same window.

Alan

[Marcol]

See if this workbook helps.

Select from the drop-down in B2.
Add to the list in Column F

[Deepak.sharma]

Assuming List A is in A1:A4 and List 2 is in F1:F4, then in G1 try:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER not just ENTER and copy down.

Thanks for your quick reply. Will give it a shot and reply soon...
Thanks a billion.

Cheers,
Deepak

[Deepak.sharma]

See if this workbook helps.

Select from the drop-down in B2.
Add to the list in Column F

Thanks Marcol,

It worked.

Cheers,
Deepak

[Deepak.sharma]

You could use the Find Icon on your Ribbon/Menu. Control +F will open the same window.

Alan

Hello Alansidman,

I have got some 10000 records in ListA and 4000 in ListB....
Now would you like to change your suggestions ??

Thanks,
Deepak

[alansidman]

Now would you like to change your suggestions ??

No need to. Marcol gave you a solution that works. Now give him some rep points.

Alan

[Richard Buttrey]

Hello Alansidman,

I have got some 10000 records in ListA and 4000 in ListB....
Now would you like to change your suggestions ??

Thanks,
Deepak

I detect an element of sarcasm/criticism here. I hope I'm wrong but if not please remember that all who post answers here give freely of their time and are genuinely trying to help you. They don't deserve that sort of comment.

If you had mentioned in your first post the volumes of data then you may well have had a different response.

Just an observation.....

[Deepak.sharma]

I detect an element of sarcasm/criticism here. I hope I'm wrong but if not please remember that all who post answers here give freely of their time and are genuinely trying to help you. They don't deserve that sort of comment.

If you had mentioned in your first post the volumes of data then you may well have had a different response.

Just an observation.....

Hi Richard,

Thanks for making me realize. Sorry for my comment and I apologize to the user(alansidman) for the same.

Regards,
Deepak