vlookup - extract all row data from "master" for the clients listed in "NewSheet"

**no dice** · 09-18-2008, 02:22 PM

Hi All,

I think I have a vlookup question...

In a "master" spreadsheet I have a few thousand rows of data in coulmns A thru R.

In a "NewSheet" spreadsheet I'd like to grab all data from the master spreadsheet where the data in column J (company name) matches any company name from NewSheet.

The ultimate goal is to extract all row data from "master" for the clients listed in "NewSheet"

Examples attached.

Can anyone help me? Thanks!

**mrice** · 09-18-2008, 03:40 PM

I suggest that you use advanced filter (on the data menu) using your list on the new sheet as the criteria range. You will need to make sure that your column headings match exactly for this to work i.e. "CompanyName" <> "Company Name"

**no dice** · 09-18-2008, 10:30 PM

Thanks... think I'd still prefer a vlookup type solution. That way I can link it once and not re-filter every time I add data to the master sheet... which is often.

**martindwilson** · 09-19-2008, 05:57 AM

i dont know how you'll achieve this with that layout.
you want to enter name in col j and retrieve data from corresponding name in master? ok which one ?the first instance, all instances.

**no dice** · 09-19-2008, 11:00 AM

You may be on to something... that I'm asking for something that cannot be done.

I have a list of ~ 70 names. These 70 names have multiple data rows within "master". Looking for a formula solution to use the list of names to retrieve all data rows for all 70 names.