Hi All,

I am facing with a fuzzy issue working with vlookup. I require to do a partial search in a range of cell.

I have two sheets. Worksheet1 contains list of IDs for ex: 000A2324GH1100
Worksheet2 is the main database where I need to do a lookup.

For ex. I want to list in Worksheet1 all the IDs that contains text 'A2324G' from Worksheet2. Could you please help me on how can I do this. I have tried FIND & SEARCH functions but did not help.

Regards,
Beginner

Hi

How many IDs will be with the text 'A2324G' . If there is going to be only one, vLookup could get you that; if there are more than one you need to chose some other method (query table etc)

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Hi Shasur

Thanks for the reply. Yes there are more than one ID with that text. Anyways I ll get some help regarding query tables from google.

Thanks

Here is how I had used it some time back (http://vbadud.blogspot.com/2007/12/q...ta-source.html). The source was from different workbook

You need to add the where clause to the SQL statement

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Hi Shasur,

Is it possible to do a Vlookup for a part of a cell. Usually I select a particular cell and do a lookup. How can a partial vlookup be done? Please help

Thanks and Regards,
Afzal

Hi Afzal

The last parameter in Vlookup can be used to find approximate values, but that will not cater to your demand. If you specify the range_lookup as false it will search for exact values

There are other functions like Find; it will get search for a string within another and get the starting character

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)