Creating a new list containg paarticular text for a current large list

[ceb]

Hi All,

I have a worksheet containing a list of names and other info. I need to create a new list from it but only selecting items with "XYZ" in column A and associated items from it othe columns.
I have tried VLOOKUP("*XYZ*",'VG Latest'!B2:B2619,1,0) and it finds the first, but when I drag it down the column it find the same item in each new cell.

Any ideas

Cheer Clive

 

[kidwispa]

Hi Clive,

If you are trying to use a vlookup to return multiple results you will be able to find the answer in the last link I posted in this thread...

http://www.mrexcel.com/forum/showthread.php?t=546647

Regards

Craig

 

[Aladin Akyurek]

A1: XYZ

A2, just enter:

=COUNTIF('VG Latest'!B2:B2619,"*"&A1&"*")

A4, control+shift+enter, not just enter, and copy down:

=IF(ROWS($A$4:A4)<=$A$2,INDEX('VG Latest'!$B$2:$B$2619,
    SMALL(IF(ISNUMBER(SEARCH(A1,'VG Latest'!$B$2:$B$2619)),
      ROW('VG Latest'!$B$2:$B$2619)-ROW('VG Latest'!$B$2)+1),
        ROWS($A$4:A4))),"")

 

[ceb]

Aladin Akyurek

Thanks for that I had to change A1 to $A$1 and it worked fine.

Cheers Clive

 

[Aladin Akyurek]

Aladin Akyurek

Thanks for that I had to change A1 to $A$1 and it worked fine.

Cheers Clive

Great. Thanks for providing feedback.