compare/filter lists with different headers

[Pat]

Hi,

Just wondering if anyone has done this before by filtering or macro?

I have the following list A with 3 columns and headers (name, biog,
biourl) - 1505 entries

I also have a list B with 1 column and header (name) - 405 entries.
(The 405 entries all appear in the list A)

I just need to strip the list A down to 1 list containing the 405
names that match between lists A and B, but with all the info from
list A (i.e. name, biog, biourl) associated to those 405 names.

Any help, greatly appreciated,

Thanks in advance,

Pat

 

[Matt Richardson]

Hi,

Just wondering if anyone has done this before by filtering or macro?

I have the following list A with 3 columns and headers (name, biog,
biourl) - 1505 entries

I also have a list B with 1 column and header (name) - 405 entries.
(The 405 entries all appear in the list A)

I just need to strip the list A down to 1 list containing the 405
names that match between lists A and B, but with all the info from
list A (i.e. name, biog, biourl) associated to those 405 names.

Any help, greatly appreciated,

Thanks in advance,

Pat

You'll need to use a vlookup function. Check out the link below:-

http://teachr.blogspot.com/2006/07/vlookup-tutorial-excel-intermediate.html

Hope this helps,
Matt Richardson
http://teachr.blogspot.com

 

[Pete_UK]

Assuming List A is in Sheet1 with your headers on row 1 and data in
columns A to C, and that your List B is in another sheet occupying
column A. It is easier to add the relevant data to List B, so put this
formula in B2 of that sheet:

=VLOOKUP($A2,Sheet1!$A$2:$C$1506,COLUMN(B1),0)

copy into C2, then copy B2:C2 down.

Hope this helps.

Pete

 

[Pat]

Thanks a million Matt and Pete!

Works a charm.

Yours very gratefully,

Pat